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

2 次查看（过去 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:
http://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-structure-array.html
and use
http://www.mathworks.com/help/matlab/ref/xlswrite.html
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
http://www.mathworks.com/help/matlab/getting-started-with-matlab.html
  3 个评论
显示 1更早的评论
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 Center 和 File 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