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

6 visualizaciones (últimos 30 días)

masoud jiryaei el 14 de Jul. de 2019

Comentada: Stephan el 14 de Jul. de 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!

Walter Roberson el 14 de Jul. de 2019

Excel is not able to represent 3d arrays. You can reshape to 2d or you can write each pane to a separate sheet.

Stephan el 14 de Jul. de 2019

Editada: Stephan el 14 de Jul. de 2019

If it would be acceptable to have all matrices in one excel sheet, you could use:

A = (reshape(your_matrix,5,[],1))'

masoud jiryaei el 14 de Jul. de 2019

thank you Stephan.

Stephan el 14 de Jul. de 2019

Did you notice that you can accept and/or vote for useful answers?

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

Más información sobre Spreadsheets en Help Center y File Exchange.

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

Translated by