- 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?
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (1)
Adam Danz
el 7 de Feb. de 2021
Editada: Adam Danz
el 9 de Feb. de 2021
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 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!