How to output specific matrix component to excel?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a 3x3x4000 array, named 'a'
I wish to output the first row, first column term of the first 500 of these into an excel sheet.
n=1:500
xlswrite('MatlabOut.xls', a(1,1,n) )
returns the error message:
"__??? Error using ==> xlswrite at 156 Dimension of input array cannot be higher than two.
Error in ==> Matlab5 at 3517 xlswrite('MatlabOut.xls', a(1,1,n)) "
What would be the best way to do this?
Any help appreciated
0 commentaires
Réponses (1)
Iman Ansari
le 8 Mai 2013
Hi. Convert it to two dimensional, then use xlswrite:
a=rand(3,3,4000);
a1=a(1,1,1:500);
a2=a1(:);
xlswrite('MatlabOut.xls',a2)
0 commentaires
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!