I have a multi dimension matrix (:,:,:) that I need to export to excel

4 views (last 30 days)
I have a multi dimension matrix (:,:,:) that I need to export to excel, The data is basically formed of 14 matrices (5*5).
(:,:,14) I tried xlswrite command but I kept getting some dimension errors. Any ideas, please! Thank you guys!
  1 Comment
Walter Roberson
Walter Roberson on 14 Jul 2019
Excel is not able to represent 3d arrays. You can reshape to 2d or you can write each pane to a separate sheet.

Sign in to comment.

Accepted Answer

Stephan
Stephan on 14 Jul 2019
Edited: Stephan on 14 Jul 2019
If it would be acceptable to have all matrices in one excel sheet, you could use:
A = (reshape(your_matrix,5,[],1))'

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!