Exporting uneven nested cells to excel

Question

aaammm 2023-3-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1922725-exporting-uneven-nested-cells-to-excel

评论： aaammm 2023-3-10

I have a 1x50 nested cell array where each cell has 3 columns but different number of rows that I need to export to excel.

I already have a loop to obtain the nested cell variable so I am using xlswrite('mydata.xlsx',data,'Sheet1') in the loop.

How can I move columns so the data is not overwritten in columns A:C for every iteration?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Voss 2023-3-5

You can set the Range of cells to be written to (xlswrite(filename,A,sheet,xlRange)), which you would adjust on each iteration of the loop.

However, it's likely easier to write the entire file once, without a loop at all.

Can you save your cell array in a .mat file and upload it here (using the paperclip button), and also share any code you have written so far for this?

请先登录，再进行评论。

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

Answer 1

Swaraj 2023-3-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1922725-exporting-uneven-nested-cells-to-excel#answer_1186050

在 MATLAB Online 中打开

Xlswrite is not recommended. Go through the below documentation.

(Not recommended) Write Microsoft Excel spreadsheet file - MATLAB xlswrite (mathworks.com)

You can go for “writecell” function. We can use it to specify range within which[JK1] we want to write data.

To avoid overwriting data in columns A:C for every iteration, you can use the Range input argument of the “writecell” function to specify the starting cell for each iteration

For example :

writecell(C,'C.xls','Sheet',2,'Range','A3:C5')

Go through the below documentation for further details.

Write cell array to file - MATLAB writecell (mathworks.com)