How to print out cell array to CSV file?

Question

TingTing 2014-3-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/119705-how-to-print-out-cell-array-to-csv-file

评论： the cyclist 2014-3-3

Hi,

I have a large cell array (600000*75). I just want to write it into CSV file. It has both numeric and text values. How shall do it?

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

请先登录，再进行评论。

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

Answer 1

the cyclist 2014-3-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/119705-how-to-print-out-cell-array-to-csv-file#answer_126671

My favorite way to do this is the cellwrite() function (from the File Exchange).

2 个评论
显示无隐藏无

TingTing 2014-3-3

Hi, thank you, but because some of my text strings have comma in it, it didn't work quite well with cellwrite...

the cyclist 2014-3-3

Did cellwrite crash or give an error? Or is it just that the output was not what you expect? If your output has commas, then even if cellwrite (or any other MATLAB function) does its job, then the program you use to open the output might format it badly because it assumes those commas are field separators.

One trick I use sometimes is to replace commas in the cell array with semicolons. You can use the regexprep() function to do that. (Obviously, that's not a good solution if you really need those commas.)

请先登录，再进行评论。