export to excel

2 visualizaciones (últimos 30 días)
Hassan
Hassan el 17 de Feb. de 2012
I have an array(18 rows, 30 columns, 4 layers) and I want to export it to excel as array(:,:,1) would be written to coulmn 1,array(:,:,2) to coulmn2,array(:,:,3) to coulmn3,array(:,:,4) to coulmn4. Could you please tell me how I can do that?

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

Sarah Wait Zaranek
Sarah Wait Zaranek el 17 de Feb. de 2012
This should work out for you. Reshape the array so it is an nx*ny by 4 and then use the xlswrite command.
A = rand(18,30,4);
Areshape = reshape(A,[18*30 4]);
xlswrite('MyTestFile.xlsx',Areshape)
  1 comentario
Hassan
Hassan el 17 de Feb. de 2012
Thanks Sarah.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

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

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by