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!