MATLAB Answers

Craig

How to output specific matrix component to excel?

Asked by Craig
on 7 May 2013

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 Comments

Tags

Products

No products are associated with this question.

1 Answer

Answer by 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)

  0 Comments


Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply today