How to output specific matrix component to excel?

1 view (last 30 days)
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

Answers (1)

Iman Ansari
Iman Ansari on 8 May 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)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!