struct with timeseries fields to Excel
16 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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.
0 Kommentare
Antworten (1)
Dheeraj Singh
am 17 Dez. 2019
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');
1 Kommentar
DB
am 18 Jan. 2021
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');
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!