Exporting a 3D file

17 次查看（过去 30 天）

Salam 2013-3-13

I am trying to export a 3D .mat file into an .xls or even a .txt file, but I cant do that as the load/write functions work only for 2D .mat files.

Any ideas?

Azzi Abdelmalek 2013-3-13

If A is your 3D array

n=size(A,3)
for k=1:n
 xlswrite('yourfile.xls',A(:,:,k),sprintf('sheet%d',k))
end

Salam 2013-3-14

The problem is that the file is large (2^9*2^9*313). Excel cant handle more than 256 columns, and I cant transpose this directly as it is a 3D array.

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

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

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

Translated by