Save Struct to Excel file
11 views (last 30 days)
Show older comments
Answered: Tim Fabian Zimmermann on 26 Oct 2021
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.
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.
More Answers (1)
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;
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?
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
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!