How to output specific matrix component to excel?
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (1개)
Iman Ansari
2013년 5월 8일
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!