export to excel

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?

Answer 1

[Sarah Wait Zaranek]

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)

[Hassan]

Thanks Sarah.