struct with timeseries fields to Excel

Question

SE 2019-12-11

评论： DB 2021-1-18

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 2019-12-17

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');

DB 2021-1-18

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');