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

4 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.

Connectez-vous pour répondre à cette question.

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)

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by