How to save a matrix having cell array into csv

Question

Jake 2013-8-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84361-how-to-save-a-matrix-having-cell-array-into-csv

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

per isakson 2013-8-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84361-how-to-save-a-matrix-having-cell-array-into-csv#answer_93935

在 MATLAB Online 中打开

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