- Use readtable to read in the data as table T.
- Use the conversion below.
- Write to csv using writetable
How can I export the below table?
6 ビュー (過去 30 日間)
古いコメントを表示
How can I export the below table?

Data = load('INPUTFILEedit.mat');
DataName = fieldnames(Data);
for k = 1:numel(DataName)
ThisName = DataName{k};
ThisData = Data.(ThisName);
tst=ThisData.Date(1:height(ThisData(2:end,2))); % just a sample set to play with
mydates = datetime(tst,'InputFormat','yyyy-MM-dd''T''HH:mm:ss.SSSSSSSSSZ ', ...
'TimeZone','Europe/London','Format','y-MM')
% size(AUDCAD)
0 件のコメント
回答 (1 件)
Adam Danz
2021 年 2 月 7 日
編集済み: Adam Danz
2021 年 2 月 9 日
T = array2table(reshape(1:18,3,[])', 'VariableNames',{'a' 'b' 'c'},'RowNames', compose('%d',0:5))
T2 = array2table([reshape(T{1:3,:},1,[]); reshape(T{4:6,:},1,[])], ...
'VariableNames', strcat(repelem(T.Properties.VariableNames,1,3), 's', compose('%d',repmat(1:3,1,3))), ...
'RowNames', {'1','2'})
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!