struct to excel data saving

20 次查看（过去 30 天）
Mudasser Seraj
Mudasser Seraj 2018-2-6
评论： Caoimhe Madine 2020-4-2
Hi, I have a 15x3x5 struct with 12 fields. I want to save all the data inside the structure in excel with one sheet for each field. How can I do that?
  1 个评论
Fangjun Jiang
Fangjun Jiang 2018-2-6
Your array size is 15x3x5. There is no way in Excel that can represent this three dimensional size. I would suggest you making it 225 (the number of structures) by 12 (the number of fields) array. You can write this array in one Excel sheet.

请先登录，再进行评论。

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2018-2-6
S=[Cars(:)];
writetable(struct2table(S),'test.xlsx');
winopen test.xlsx

更多回答（1 个）

Raj Sodhi
Raj Sodhi 2019-9-29
I found that my struct had sub-structs and those structs had arrays within those elements. So I wrote a little better solution that might be worth sharing. See attached function.
Yours,
Raj
  1 个评论
Caoimhe Madine
Caoimhe Madine 2020-4-2
Would you be able to give some guidance on where in this code you input your own files and names. It is not quite clear to me

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by