export MATLAB cell array into a csv file

Question

I wish to write a some information in form of a csv file from a MATLAB code.

In the MATLAB code I have stored the header as a cell array:

ToCSV={'Location' 'Weight_factor' 'Average' 'Maximum' 'Minimum'};

I append rows to this cell array by looping. A sample statement is:

ToCSV={ToCSV; {'EastLocation' 0.5 1e+3 1e+4 1e+2} };

I wish to print this as a csv file. I used following routine which sort of giving errors:

fid = fopen('outfile.csv','w');
fprintf(fid,'%s, %s, %s, %s, %s\n',ToCSV{1,:});
fprintf(fid,'%s, %f, %10.2e, %10.2e, %f\n',ToCSV{2:end,:});
fclose(fid);

>>Error using fprintf
>>Function is not defined for 'cell' inputs.

Can some of you please provide pointers to achieve this? I also tried csvwrite, but apparently it doesn't go well with cell arrays.

I was gonna suggest using tables and writetable function, but I guess that might not be available in your version. — Xiaolei Zhu
– Xiaolei Zhu, Commented Dec 5, 2013 at 4:56

chappjc · Accepted Answer · 2013-12-05 04:12:07Z

2

The problem is with the following statement

ToCSV={ToCSV; {'EastLocation' 0.5 1e+3 1e+4 1e+2} };

This makes a cell array inside a cell array so that when you index ToCSV you get a cell array. I think you want to concatenate a row like this:

ToCSV=[ToCSV; {'EastLocation', 0.5, 1e+3, 1e+4, 1e+2} ];

or

ToCSV(end+1,:) = {'EastLocation', 0.5, 1e+3, 1e+4, 1e+2};

The commas just make it easier to read.

answered Dec 5, 2013 at 4:12

chappjc

30.6k7 gold badges79 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lennon310 · Accepted Answer · 2013-12-05 04:15:48Z

1

aa=ToCSV{1,:};
bb=ToCSV{2,:};
fid = fopen('outfile.csv','w');
fprintf(fid,'%s, %s, %s, %s, %s\n',aa{:});
fprintf(fid,'%s, %f, %10.2e, %10.2e, %f\n',bb{:});
fclose(fid);

answered Dec 5, 2013 at 4:15

lennon310

12.7k11 gold badges46 silver badges63 bronze badges

2 Comments

chappjc Over a year ago

He's looping. When the concatenation runs a second time, this breaks.

lennon310 Over a year ago

You are right. Thank you for pointing out. I +1 to your answer, that works.

Collectives™ on Stack Overflow

export MATLAB cell array into a csv file

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related