struct to excel data saving

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?

[Fangjun Jiang]

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.

Answer 1

[Fangjun Jiang]

S=[Cars(:)];
writetable(struct2table(S),'test.xlsx');
winopen test.xlsx

[Mudasser Seraj]

Thank you so much. It worked well.

Answer 2

[Raj Sodhi]

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

[Caoimhe Madine]

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