How to write cell array into a csv file

Question

Jalaj Bidwai 2013-4-5

2
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file

回答： Vibhav Gaur 2021-6-21

Hello Everyone, I have a cell array C where the first row is string and the remaining rows contain numbers. How do I write the variable C into a CSV file?

For example,

c = {'abc' 'def' 'ghk';[23],[24],[67];[87],[13],[999];[656],[6767],[546]};

Thanks

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

请先登录，再进行评论。

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

Answer 1

Cedric 2013-4-5

27
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file#answer_81155

编辑：MathWorks Support Team 2018-11-27

在 MATLAB Online 中打开

To write the data in C to a CSV file. Use “writetable” in combination with the “cell2table” function.

% Convert cell to a table and use first row as variable names
T = cell2table(c(2:end,:),'VariableNames',c(1,:))
 
% Write the table to a CSV file
writetable(T,'myDataFile.csv')

For more information see:

https://www.mathworks.com/help/matlab/ref/writetable.html

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

Image Analyst 2015-10-19

Sara Khalifa's flag moved here:

Great Solution. Thanks!

Bidisha Das 2018-8-29

What if I want the csv file in append mode?

请先登录，再进行评论。

Answer 2

Jon 2013-4-5

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file#answer_81161

在 MATLAB Online 中打开

You could do it as follows with fprintf

c = {'abc' 'def' 'ghk';[23],[24],[67];[87],[13],[999];[656],[6767],[546]}; 
  fid = fopen('junk.csv','w')
  fprintf(fid,'%s, %s, %s\n',c{1,:})
  fprintf(fid,'%f, %f, %f\n',c{2:end,:})
  fclose(fid)

6 个评论
显示 4更早的评论隐藏 4更早的评论

Jalaj Bidwai 2013-4-8

Jonathan,Fanstastic. Both of the ways have worked for me..Thank you for the help..I really aprreciate it...

Harsha Vardhana Padullaparti 2016-6-16

Jonathan, Perfect! Thanks so much for your input.

请先登录，再进行评论。

Answer 3

Vibhav Gaur 2021-6-21

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file#answer_729815

在 MATLAB Online 中打开

writecell(c, 'c.csv')

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

请先登录，再进行评论。

Answer 4

Azzi Abdelmalek 2013-4-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file#answer_81136

编辑：Azzi Abdelmalek 2013-4-5

use csvwrite functionn

2 个评论
显示无隐藏无

Jon 2013-4-5

csvwrite only works on numeric arrays, not cell arrays with strings and numbers

Youcef Yahiaoui 2015-9-19

Azzi,good to see your comments here. I usually use fprintf(fid...) for the first header lines then use csvwrite with the option -append...

请先登录，再进行评论。

Answer 5

Zumbo_123 2016-1-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file#answer_205368

Alternatively, you could use the method developed by Sylvain Fiedler. Below is the link to the file. It works with empty cells, numeric, char, string and logical cells. One array can contain all of them, but only one value per cell.

http://www.mathworks.com/matlabcentral/fileexchange/4400-cell-array-to-csv-file--cell2csv-m-

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

请先登录，再进行评论。

Answer 6

Peter Farkas 2017-10-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file#answer_284961

Convert to table and use writetable function T = cell2table(c(2:end, :)); T.Properties.VariableNames = c(1:end, :); writetable(T, res.csv);

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

请先登录，再进行评论。

Answer 7

Aaron Thrasher 2018-4-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/70018-how-to-write-cell-array-into-a-csv-file#answer_316294

在 MATLAB Online 中打开

I came to this page looking for an answer and found that all solutions were very slow for large arrays that include numeric and char based cell arrays of non-standard combinations. Instead, I created my own based off of previous comments and other research. I hope this helps someone as it has helped me reduce the time significantly.

function cellWrite(filename,origCell)
% save a new version of the cell for reference
modCell = origCell;
% assume some cells are numeric, in which case set to char
iNum = cellfun(@isnumeric,origCell);
%% Method 1 using indexing and straight conversion = 7 sec
tic
modCell(iNum) = cellstr(num2str([origCell{iNum}]'));
% toc
%% Method 2 using arrayfun = 25 sec
% tic
% modCell(iNum) = arrayfun(@num2str,[origCell{iNum}],'unif',0);
% toc

% tic
[rNum,cNum] = size(origCell);
frmt = repmat([repmat('%s,',1,cNum-1),'%s\n'],1,rNum);
fid = fopen(filename,'w');
fprintf(fid,frmt,modCell{:});
fclose(fid);
toc