Save Struct to Excel file

Question

Tim Fabian Zimmermann 2021-10-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1571973-save-struct-to-excel-file

回答： Tim Fabian Zimmermann 2021-10-26

Screenshot 2021-10-26 133353.png

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 2021-10-26

What do you mean it didn't work? What happened with writetable when you tried it?

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:

请先登录，再进行评论。

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

Answer 1

Tim Fabian Zimmermann 2021-10-26

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1571973-save-struct-to-excel-file#answer_817058

I did it with an table now, defining my talbe befor the loop as

varTypes = {...

'string',...

'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!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Can Atalay 2021-10-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1571973-save-struct-to-excel-file#answer_816918

编辑：Can Atalay 2021-10-26

在 MATLAB Online 中打开

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更早的评论隐藏 1更早的评论

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 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

请先登录，再进行评论。