export to excel

2 次查看（过去 30 天）
Hassan
Hassan 2012-2-17
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?

请先登录，再回答此问题。

采纳的回答

Sarah Wait Zaranek
Sarah Wait Zaranek 2012-2-17
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)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by