How to save a matrix having cell array into csv
Show older comments
Hi,
I really want your help. Here is my code...
name = [{Jake}; {Mike}];
age = [24; 22];
age = cellstr(num2str(age));
list = [name age];
fid=fopen('list.csv','w');
fprintf(fid, '%s\n',list{:,:});
fclose(fid);
The code seen above doesn't make two different columns but a single column. How can I break 'list' into two different column into csv file? Please help me out.
Thank you in advance.
Answers (1)
per isakson
on 8 Aug 2013
This is a more standard approach (without list)
name = {'Jake'; 'Mike'};
age = [24; 22];
fid=fopen('list.csv','w');
for jj = 1 : length( name )
fprintf( fid, '%s,%d\n', name{jj}, age(jj) );
end
fclose(fid);
Categories
Find more on Creating and Concatenating Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!