writing/ exporting 3D data set/matrix from Matlab to EXCEL
조회 수: 8 (최근 30일)
이전 댓글 표시
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
Joseph Cheng
2016년 2월 3일
How do you expect excel to handle a 3d matrix? How do you want the 3rd dimension to be represented in excel?
채택된 답변
Walter Roberson
2016년 2월 3일
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
Walter Roberson
2016년 2월 3일
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
추가 답변 (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!