Writing 3D array to excel sheet

33 次查看（过去 30 天）
Zee
Zee 2022-6-3
编辑： Dhanush Yeddula 2022-6-7
Hello,
I would like to write Matlab output having dimension 2040x5x174 to an excel sheet. xlswrite function is restricted for 2D array as I get following error: 'Dimension of input array cannot be higher than two.'
Is there any other function that I can use or any other way to write this. Thanks.
  1 个评论
Walter Roberson
Walter Roberson 2022-6-3
Either reshape() or write the slices to separate sheets. Excel has no support for 3d arrays.

请先登录，再进行评论。

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

采纳的回答

Dhanush Yeddula
Dhanush Yeddula 2022-6-7
编辑：Dhanush Yeddula 2022-6-7
The function “xlswrite” can handle only 2D data. In order to write your 3D data you can either reshape the data into a large 2D array, or you can run a loop to save each sheet of your data to a sheet of the excel file. The conversion from 3D to 2D can be done in a couple of ways. The following examples demonstrate these techniques:
%% Example 1
a = rand(3,3,3)
for i = 1:3
% use a for loop to remove 1 dimension and write into different worksheets
b = (squeeze(a(i,:,:)))'
xlswrite('exanple1.xls', b, ['Sheet', num2str(i)])
end
%% Example 2
a = rand(3,3,3)
% use reshape to remove 1 dimension
b = reshape(a,3,9)
xlswrite('example2.xls', b)

更多回答（0 个）

类别

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

标签

产品


版本

R2011b

Community Treasure Hunt

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

Start Hunting!

Translated by