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

5 vues (au cours des 30 derniers jours)
masoud jiryaei
masoud jiryaei le 14 Juil 2019
Commenté : Stephan le 14 Juil 2019
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 commentaire
Walter Roberson
Walter Roberson le 14 Juil 2019
Excel is not able to represent 3d arrays. You can reshape to 2d or you can write each pane to a separate sheet.

Connectez-vous pour commenter.

Réponse acceptée

Stephan
Stephan le 14 Juil 2019
Modifié(e) : Stephan le 14 Juil 2019
If it would be acceptable to have all matrices in one excel sheet, you could use:
A = (reshape(your_matrix,5,[],1))'
  2 commentaires
masoud jiryaei
masoud jiryaei le 14 Juil 2019
thank you Stephan.
Stephan
Stephan le 14 Juil 2019
Did you notice that you can accept and/or vote for useful answers?

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by