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

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

Answer 1

[Jan]

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).

[Cordelle]

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]

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')

Answer 2

[Shashank Prasanna]

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

[Cordelle]

Error using load

Number of columns on line 3 of ASCII file

\\dc1nas\Projects-AB\AS\Jobs\Jobs-2012\1538_KSAT_SG24\40_Testin\03_Test_Report\SAT\SAT_Demo_Passes\passReport.TERRA_2013_107_165606

must be the same as previous lines.

How can i correct this issue? (I used the "Load" input routine)

[Shashank Prasanna]

Since you are new to MATLAB, try using this GUI

http://www.mathworks.com/help/matlab/import_export/import-data-interactively.html

[Jan]

Please do not post explanations like "I used the "Load" input routine", but the corresponding code. This will reduce misunderstandings. Thanks.

Answer 3

[Harish TV]

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---------------------']);

[Guillaume]

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)