How to write a matrix (4 x 3) into a csv file

Question

Jake 2016-10-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/307947-how-to-write-a-matrix-4-x-3-into-a-csv-file

评论： Walter Roberson 2016-10-21

Hi MATLAB experts, I want to write a cell matrix into a csv file as you can see below, called 'output'. At the moment, I am using a function of fprintf with for loop, which has no issues to use as is.

However, in a csv file, I also want to have a header on top of the matrix such as head

 header = {'date', 'Name', 'Score}; 
output = 
         [42661]    [1x40 char]    [200]
         [42661]    [1x40 char]    [201]
         [42661]    [1x40 char]    [202]
        .
        .
        .
        .
         [42661]    [1x40 char]    [210]
fid=fopen(['C:\MATLAB\output.csv'],'w');
for z = 1:size(output,1)
fprintf(fid, '%d,%s,%d\n', output {z,1}, output {z,1}, output {z,1});
end
fclose(fid);

How can I add the header to this matrix to write into a csv file??

Thanks for your help in advance. Sungho

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-10-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/307947-how-to-write-a-matrix-4-x-3-into-a-csv-file#answer_239626

在 MATLAB Online 中打开

After the fopen,

fprintf(fid, '%s,%s,%s/n', header{:} ) ;

3 个评论
显示 1更早的评论隐藏 1更早的评论

Jake 2016-10-21

Thanks!! This works perfect. However, when writing numbers with decimals, MATLAB writes those numbers with decimals as Scientific instead of General which I want to keep in the spreadsheet.

How can I do to keep the numbers with decimals in General????

Thanks for your help.