MATLAB: How to export struct with many substruct into excel

import excelmatfile to excelstructstructures to excelsubstruct

Hello,

I have a question with how to import struct with sub structs matfile into excel.

I tried struct2cell and others, however I am having some difficulties.

WIth in the 'FA.parameter' struct there are

2. there are 4parameters 'TZ1','TZ2','TZ3','TZ4' struct

3. Within each TZ1,2,3,4 there are 15 values (f1…f15) I would like to import to the EXCEL

Would someone please help me to transform this into excel format?

Thank you.

Best Answer

Hi,

The ideal way is to reach the internal structure and loop through the values and save them in a excel file.

This link1 and link2 helps you to achieve the above task and modify as per requirements.

Hope this helps.

Related Solutions

MATLAB: Can matlab save a structure to an excel file so that each individual field is saved to one excel sheet

You may use the following code

% Let the name of structure be s
f = fields(s) % get the fields of the structure
for i = 1:n % n is the number of fields in structure
    writetable(s.(f{i}),'Example.xlsx','Sheet',i)
end

MATLAB: Substruct array disappear when a struc object is assigned

Luca - the substructure (for the second element) doesn't disappear as it was never there to begin with. Since you are initializing it for the first time with

 S.A.A_ID(2).C='test2';

then the D and E will be set with default values of the empty matrix for each. You would need to copy the elements over from S.A.A_ID(1).

Remember, when you initialize your S as above, then

 numel(S.A.A_ID)

is just one. There is no second element, and S.A.A_ID is identical/equivalent to S.A.A_ID(1).

Best Answer

Related Solutions

MATLAB: Can matlab save a structure to an excel file so that each individual field is saved to one excel sheet

MATLAB: Substruct array disappear when a struc object is assigned

Related Question