how to convert a .txt file into a .xls file in matlab?

조회 수: 7 (최근 30일)
Cordelle
Cordelle 2013년 6월 18일
댓글: Guillaume 2017년 3월 17일
I suspect that I can actually read the log file data directly into Matlab without conversion. It is just a comma separated variable format(.csv), I believe, and I think it should be accessible to some Matlab input routine.
However,I dont not know the matlab input routine; It would be very helpful if someone can enlighten me on the input routine
thanks in advance, Cordelle

답변 (3개)

Jan
Jan 2013년 6월 18일
This is not enough information to give a more explicit answer than:
  • Import the file by e.g. importdata or fopen / fscanf.
  • Export the data by xlswrite.
I suggest to add mire details, e.g. the file's contents by editing the original question (not as comment or answer).
  댓글 수: 2
Cordelle
Cordelle 2013년 6월 18일
편집: Cordelle 2013년 6월 18일
When I imported the file using importdata this occured:
data: 3
textdata: {863x4 cell}
what does this mean? and how can I convert the imported file into an excel file?
Iain
Iain 2013년 6월 18일
편집: Iain 2013년 6월 18일
That means that data is a structure containg the field "textdata", and that "textdata" contains a cell array (each element of a cell array can be a different type of number, string, or even another array).
Try:
xlswrite('myxl.xls',data.textdata)
winopen('myxl.xls')

댓글을 달려면 로그인하십시오.


Shashank Prasanna
Shashank Prasanna 2013년 6월 18일
That means its a cell in a structure.
You can access data from structures:
and use
If you need editing in between you should do that.
If you are unfamiliar with cell and structures at all in MATLAB, I point you to
  댓글 수: 3
Jan
Jan 2013년 6월 18일
Please do not post explanations like "I used the "Load" input routine", but the corresponding code. This will reduce misunderstandings. Thanks.

댓글을 달려면 로그인하십시오.


Harish TV
Harish TV 2017년 3월 17일
clear; clear all; fileip='filename.csv'; g=char(fileip); g=g(1:end-4) fileop=horzcat(g,'.xlsx') g=fileip(1:end-4); [~,~,F]=xlsread(fileip); F=cellstr(F); %delete the header rows (4 rows) F([1:4],:)=[]; for a=1:size(F,1); b=F(a,1); c=char(b); D(a,:)=strsplit(c,','); end xlswrite(fileop,D); disp(['--------------Process complete---------------------']);
  댓글 수: 1
Guillaume
Guillaume 2017년 3월 17일
There's a {}Format button to format code as such. That would make your post more readable.
g = char(fileip);
is a no-op. fileip is already char. In any case,
[path, basename] = fileparts(fileip);
fileop = fullfile(path, [basename, '.xlsx']);
would be a lot simple and safer.
F = cellstr(F);
is also a no-op. F is already a cell array. Same for
c = char(b); %b is already char.
In any case, the code is not going to work. It only writes the first column of the csv file. (hint: xlsread already does the splitting at the comma)

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Standard File Formats에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by