.MAT file with multiple tabs/sheets

Question

Saeid 2023-6-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1985084-mat-file-with-multiple-tabs-sheets

评论： Walter Roberson 2023-6-19

I would like to copy the contents of a multi-sheet excel file into a .mat file. Is it possible to have a multi-sheet .MAT file? If not, what would be the alternative (other than having a single .mat file for each excel sheet)?

2 个评论
显示无隐藏无

Stephen23 2023-6-19

编辑：Stephen23 2023-6-19

"Is it possible to have a multi-sheet .MAT file?"

A MAT file is just a container, you can save anything in it: the MAT file binary format lets you store any number of arrays of any MATLAB class of any size. The simplest apporoach would be to import them into one cell array and SAVE that.

A MAT file is not one matrix.

Walter Roberson 2023-6-19

Is it possible to have a multi-sheet .MAT file?

No

MAT files do not have the concept of sheets. You can use a structured datatype, such as struct (as @Ive J shows), or as cell arrays, or as a table containing tables, or various other possibilities.

请先登录，再进行评论。

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

Answer 1

Ive J 2023-6-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1985084-mat-file-with-multiple-tabs-sheets#answer_1258849

编辑：Ive J 2023-6-19

在 MATLAB Online 中打开

you can do something like this, and write each sheet to fields of a structure:

snames = sheetnames("myfile.xlsx");
out = struct;
for k = 1:numel(snames)
    fi = matlab.lang.makeValidName(snames(k));
    out.(fi) = readtable("myfile.xlsx", Sheet=snames(k), VariableNamingRule="preserve");
end
save("myfile.mat", "out")