Save Struct to Excel file
30 views (last 30 days)
Show older comments
Tim Fabian Zimmermann
on 26 Oct 2021
Answered: Tim Fabian Zimmermann
on 26 Oct 2021
Hey There,
im doing fricntion tests at my institute for my thesis and i have a struct which and i tried everything to save it as an .xlsx excel-file
Here is one way i tried:
fname_11 = '/Excel/Alle_Ergebnisse.xlsx';
writetable(struct2table(summary), [pwd fname_11]);
the struct is in my workplace like u can see in the screenshot.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/779103/image.png)
i tried https://de.mathworks.com/matlabcentral/answers/490251-use-a-string-as-a-struct-name and https://de.mathworks.com/matlabcentral/answers/258880-how-to-save-struct-data-from-struct-to-excel
and nothing worked. Does anyone has a clue how i can solve it? Im still new to Matlab, so sorry for the inconvinience.
2 Comments
Matt J
on 26 Oct 2021
What do you mean it didn't work? What happened with writetable when you tried it?
Accepted Answer
More Answers (1)
Can Atalay
on 26 Oct 2021
Edited: Can Atalay
on 26 Oct 2021
Since you said you were new I'm assuming you couldn't extract the tables before writing to an excel file. For instance you could access the tables using
v_7_temp = summary.v7vc10fn122;
class(v_7_temp)
and write the table to an excel file as usual.
How do you want the excel file result to look like though? A clickable cell that opens up multiple files or just a simple table view?
3 Comments
Can Atalay
on 26 Oct 2021
I don't work with excel files often so I'm not sure I understand what you're after. Maybe if you attached a hand drawing of what the xls file should look like and explain it like I'm a 3 year old I may be able to help :P sorry
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!