writing/ exporting 3D data set/matrix from Matlab to EXCEL
5 views (last 30 days)
Show older comments
Amine Ben Ayara
on 2 Feb 2016
Commented: Walter Roberson
on 3 Feb 2016
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 Comments
Joseph Cheng
on 3 Feb 2016
How do you expect excel to handle a 3d matrix? How do you want the 3rd dimension to be represented in excel?
Accepted Answer
Walter Roberson
on 3 Feb 2016
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 Comments
Walter Roberson
on 3 Feb 2016
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
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!