writing/ exporting 3D data set/matrix from Matlab to EXCEL
8 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Amine Ben Ayara
il 2 Feb 2016
Commentato: Walter Roberson
il 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 Commenti
Joseph Cheng
il 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?
Risposta accettata
Walter Roberson
il 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 Commenti
Walter Roberson
il 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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!