How to save a struct into a excel sheet one specifically?

Question

dharmin 2023-7-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1990933-how-to-save-a-struct-into-a-excel-sheet-one-specifically

回答： Voss 2023-7-2

Results.mat

Good evening, community! Could someone kindly assist me in saving data from a struct to an Excel sheet? Specifically, I would like to store different data on multiple sheets, all following the same format. Essentially, I aim to save all the different results in a single Excel file. I have attached a file that contains the variable I am working with. Thank you in advance for your help!

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

请先登录，再进行评论。

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

Answer 1

Voss 2023-7-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1990933-how-to-save-a-struct-into-a-excel-sheet-one-specifically#answer_1266058

在 MATLAB Online 中打开

Use the 'Sheet' argument in writecell.

fn = 'your_excel_file.xlsx';
% writing some simple cell arrays because I don't know what from your
% Results struct goes into each sheet or what the format should be.
writecell({1 2; 3 4},fn,'Sheet',1);
writecell({5 6; 7 8},fn,'Sheet',2);
Warning: Added specified worksheet.