How to save struct data from struct to excel?

300 次查看（过去 30 天）
Ann G
Ann G 2015-12-4
评论： Kip Risch-Andrews 2022-11-9
How can I save the output data of my matlab code in an excel file when the data are struct?

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

采纳的回答

Guillaume
Guillaume 2015-12-4
We could do with a lot more details about what you want to do. Do you want the field names to be saved? Is the structure scalar or an array? But at the simplest:
writetable(struct2table(yourstructure), 'someexcelfile.xlsx')
Note that Excel is a tabular format, whereas structures are not. The two are not really the same thing.
  11 个评论
显示 9更早的评论
Muhammad Amirul Hafiz Sahful Bahri
Muhammad Amirul Hafiz Sahful Bahri 2019-5-8
I have an error something like this,
Error using struct2table (line
26)
Input structure must be a
scalar structure, or a
structure array with one column
or one row.
Error in beginner (line 17)
writetable(struct2table(S{1,1}),'someexcelfile.xlsx');
How can i solve this problem?

请先登录，再进行评论。

更多回答（1 个）

Raj Sodhi
Raj Sodhi 2019-9-29
In some cases you have a struct as an element of a struct. So I found it necessary to find only those an output those to the Excel file.
txt = fieldnames(strct) ;
sel = ones(size(txt)) ;
for i = 1:length(txt)
sel(i) = isstruct(strct.(txt{i})) ;
end
i_not_struct = find(~sel) ;
i_struct = find(sel) ;
x = [fieldnames(strct) struct2cell(strct)] ;
xlswrite(xlsfile ,x(i_not_struct,:),1,'a1') ; % winopen(xlsfile)
Then I treat the struct elements separately, as shown in the attached file.
Yours,
Raj
  2 个评论
Varun Vakayil
Varun Vakayil 2022-8-16
Thank you so much Raj. This was exactly what I was looking for.
Kip Risch-Andrews
Kip Risch-Andrews 2022-11-9
This works perfectly for structures with many substructs, thanks for posting it!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by