writing/ exporting 3D data set/matrix from Matlab to EXCEL
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Amine Ben Ayara
el 2 de Feb. de 2016
Comentada: Walter Roberson
el 3 de Feb. de 2016
I have a multi dimension matrix (:,:,:) that I need to export to excel, The data is basically formed of 44040 (5*5) matrices. (:,:,44040) I tried xlswrite command but I kept getting some dimension errors. Any ideas, please! Thank you guys!
2 comentarios
Joseph Cheng
el 3 de Feb. de 2016
How do you expect excel to handle a 3d matrix? How do you want the 3rd dimension to be represented in excel?
Respuesta aceptada
Walter Roberson
el 3 de Feb. de 2016
xlswrite() of reshape(YourArray, size(YourArray,1), []) and be sure to use an .xlsx output (you would have too many rows for .xls)
It would be possible to create a spreadsheet with 44040 "sheets" each of which is 5 x 5, but that would seem to be a bit of a waste.
2 comentarios
Walter Roberson
el 3 de Feb. de 2016
X2 = X(:,2);
for K = 1 : 100;
X(:,2) = X2 + K;
...
end
Or since you are incrementing by 1 each time,
for K = 1 : 100
X(:,2) = X(:,2) + 1;
...
end
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!