Write a cell array to a .csv file

48 次查看（过去 30 天）
Damith
Damith 2014-11-25
回答： Walter Roberson 2022-1-14
Hi,
I have a cell array "newdata" as shown below.
'01/01/2001' 0
'02/01/2001' 0
'03/01/2001' 0
'04/01/2001' 0
'05/01/2001' 14.1000000000000
'06/01/2001' 0
'07/01/2001' 0
I need to write this to a .csv file. So, I used the following code to do that.
csvwrite('110416.csv',newdata(:,1:2));
But, I got the following error.
Error using dlmwrite (line 112)
The input cell array cannot be converted to a matrix.
Error in csvwrite (line 42)
dlmwrite(filename, m, ',', r, c);
Can somebody suggest me a different way or how to correct this.?
Thanks in advance.

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

回答（3 个）

Geoff Hayes
Geoff Hayes 2014-11-25
Damith - see Export Cell Array to Text File which uses fprintf to write each row of your cell array to file.
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2022-1-14
These days, use writecell()
D. benoy
D. benoy 2014-11-26
Hi,
If you have EXCEL on your computer you can do the following instead
xlswrite('110416.xls',y);
Open 110416.xls and save it as a csv file.
  3 个评论
显示 1更早的评论
Preston Dial
Preston Dial 2018-7-25
I am getting the same error from the xlswrite function for one of my projects

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by