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

5 次查看（过去 30 天）
dharmin
dharmin 2023-7-2
回答： Voss 2023-7-2
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!

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

采纳的回答

Voss
Voss 2023-7-2
Ran in:
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by