How to print out cell array to CSV file?

1 次查看(过去 30 天)
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?

采纳的回答

the cyclist
the cyclist 2014-3-1
My favorite way to do this is the cellwrite() function (from the File Exchange).
  2 个评论
TingTing
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
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.)

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Startup and Shutdown 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by