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

1 次查看（过去 30 天）
Jake
Jake 2016-10-18
评论： 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

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

采纳的回答

Walter Roberson
Walter Roberson 2016-10-18
After the fopen,
fprintf(fid, '%s,%s,%s/n', header{:} ) ;
  3 个评论
显示 1更早的评论
Jake
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Java Package Integration 的更多信息

标签

尚未输入任何标签。

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by