Save Struct to Excel file

34 次查看（过去 30 天）
Tim Fabian Zimmermann
回答： Tim Fabian Zimmermann 2021-10-26
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.
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 个评论
Matt J
Matt J 2021-10-26
What do you mean it didn't work? What happened with writetable when you tried it?
Tim Fabian Zimmermann
Tim Fabian Zimmermann 2021-10-26
Sorry,
i get the following Error:
"Writing nested tables/timetables is not supported. Use SPLITVARS on the nested table before writing."
Each of the Struct tables contains three values like this:

请先登录，再进行评论。

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

采纳的回答

Tim Fabian Zimmermann
I did it with an table now, defining my talbe befor the loop as
varTypes = {...
'string',...
'doubleNaN',...
'doubleNaN',...
'doubleNaN',...
} ;
Zusammenfassung=...
table('Size',[counter_folder 4],...
'VariableTypes',varTypes,...
'VariableNames',{'Versuch','Mean_Fn', 'Mean_Ft', 'Mean_mu'}...
);
and collected the values at the end like:
Zusammenfassung{i,1}=convertCharsToStrings(data_name);
Zusammenfassung{i,2}=Ergebnisse.Mittelwerte.Mean_Fn;
Zusammenfassung{i,3}=Ergebnisse.Mittelwerte.Mean_Ft;
Zusammenfassung{i,4}=Ergebnisse.Mittelwerte.Mean_mu;
after that i exported it to excel with writtable
fname_11 = '/Excel/Alle_Ergebnisse.xlsx';
writetable(Zusammenfassung, [pwd fname_11]);
thx for all your help guys!

更多回答（1 个）

Can Atalay
Can Atalay 2021-10-26
编辑：Can Atalay 2021-10-26
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 个评论
显示 1更早的评论
Tim Fabian Zimmermann
Tim Fabian Zimmermann 2021-10-26
Due to tha fact that i have several hundreds of tests with different parameter sets, it would be perfect to use the nested coulmn desctribtion like "v100vc40fn137" as the Test number
Can Atalay
Can Atalay 2021-10-26
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

请先登录，再进行评论。

类别

在 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