struct with timeseries fields to Excel

Hi all,

i have a 1x1 struct with 58 fields (1x1 double timeseries):

Each timeseries-field has a "Time" and "Data" column, e.g.:

So how can I now make an Excel export of the entire struct?

Unfortunately, the following just exports the field names but not the field data:

S=[test_data(:)];
writetable(struct2table(S),'test.xlsx');

Thanks.

Answer 1

[Dheeraj Singh]

You can use the following code for implementing the above:

arr = struct2array(test_data);
t = array2table([arr.Time;arr.Data],'VariableNames',{'Time','Data'});
writetable(t,'test.xlsx');

[David Baas]

Hi, I have tried this and got this error:

Check for missing argument or incorrect argument data type in call to function 'struct2cell'.

Error in struct2array (line 10)
c = struct2cell(s);

What do you think this means?

I have a similar dataset but with one column t, and 7 columns of data from Simulink, named out.conout:

arr = struct2array(out.conout);
t = array2table([arr.Time;arr.Data],'VariableNames',{'Time','Data'});
writetable(t,'test.xlsx');