How to write multiple heterogeneous vectors data stored in a 1 row cell array into a csv file?

Question

Amos Gdalyahu 2016-11-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/311398-how-to-write-multiple-heterogeneous-vectors-data-stored-in-a-1-row-cell-array-into-a-csv-file

回答： Prannay Jain 2016-11-14

I have a cell array MyCellArray= {[1,2], [1,2,3,4], [1,2,3], [0,999, 1]}; I want to get the data in a csv file organized as the following:

 1   1   0
 2   2   999
 3    1
    4

How to do that?

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

请先登录，再进行评论。

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

Answer 1

Prannay Jain 2016-11-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/311398-how-to-write-multiple-heterogeneous-vectors-data-stored-in-a-1-row-cell-array-into-a-csv-file#answer_243269

在 MATLAB Online 中打开

csvwrite(filename,M) does not accept cell arrays for the input matrix M. However, you could use 'xlswrite' as shown below and save the .xls file to .csv file.

>> xlswrite('xlsexample.xls',c{1}.','Sheet1','A1');
>> xlswrite('xlsexample.xls',c{2}.','Sheet1','B1');
>> xlswrite('xlsexample.xls',c{3}.','Sheet1','C1');
>> xlswrite('xlsexample.xls',c{4}.','Sheet1','D1');

I am assuming you would like to save c{1} which is a row vector into 'A1' cell of Excel as a column vector, hence I am using the transpose of c{1} = c{1}.' in 'xlswrite'.