writing/ exporting 3D data set/matrix from Matlab to EXCEL
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Amine Ben Ayara
le 2 Fév 2016
Commenté : Walter Roberson
le 3 Fév 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 commentaires
Joseph Cheng
le 3 Fév 2016
How do you expect excel to handle a 3d matrix? How do you want the 3rd dimension to be represented in excel?
Réponse acceptée
Walter Roberson
le 3 Fév 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 commentaires
Walter Roberson
le 3 Fév 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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!