How to save struct data from struct to excel?
显示 更早的评论
How can I save the output data of my matlab code in an excel file when the data are struct?
采纳的回答
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 个评论
Ann G
2015-12-4
Guillaume
2015-12-4
You must be using an old version of matlab. struct2table was introduced in 2013b if I recall correctly.
You can use
xlswrite('someexcelfile.xlsx', struct2cell(yourstructure))
but if you want the field names as header, you need to add them yourselves at the first row of the cell array.
Ann G
2015-12-6
Ann G
2015-12-6
As I said to start with, more details about your structure and how you want to save it are required.
My guess is that the missing data is because the field of the structure is not a scalar number or string. Maybe another structure, maybe an array? If that is the case, how are you expecting that to appear in excel?
The best thing would be to show us an example of the structure and an example of the expected excel file that goes with it.
Ann G
2015-12-6
Guillaume
2015-12-7
I'm assuming you meant this function that is called GLCM_Features1 and not GLCM_Features. Don't make it harder to answer your question, in the future provide links.
Assuming this is the correct function, then out is indeed a 1x1 structure, and each field is a 1xk row vector, where k is the third dimension of your glcm. In that case:
c = struct2cell(out);
xlswrite('somefile.xlsx', vertcat(c{:});
%or if you want the field names:
xlswrite('somefile.xlsx', [fieldnames(out), num2cell(vertcat(c{:}))]);
Ann G
2015-12-7
Guillaume
2015-12-8
You're not causing trouble. I was trying to convey to you that giving more (and accurate) details of what you have and want would make it much easier to answer your question.
In this case, we needed to know that you had a scalar structure where all the fields contained row vectors of identical size.
The solution was therefore to concatenate the row vectors vertically into a matrix and pass that to excel.
elz tomz
2018-7-4
Thank you Guillaume. It works fine
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
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
2022-8-16
Thank you so much Raj. This was exactly what I was looking for.
Kip Risch-Andrews
2022-11-9
This works perfectly for structures with many substructs, thanks for posting it!
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
