writing/ exporting 3D data set/matrix from Matlab to EXCEL
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Amine Ben Ayara
am 2 Feb. 2016
Kommentiert: Walter Roberson
am 3 Feb. 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 Kommentare
Joseph Cheng
am 3 Feb. 2016
How do you expect excel to handle a 3d matrix? How do you want the 3rd dimension to be represented in excel?
Akzeptierte Antwort
Walter Roberson
am 3 Feb. 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 Kommentare
Walter Roberson
am 3 Feb. 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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!