struct with timeseries fields to Excel
17 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (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');
1 件のコメント
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');
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!