Read and process multiple sheets from Excel to Matlab

Question

Francesca Danielli 2021-12-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1615435-read-and-process-multiple-sheets-from-excel-to-matlab

编辑： Stephen23 2021-12-21

采纳的回答： Stephen23

Hi!

I have an Excel file with N sheets.

Each sheet contains two coloumns (x and y coordinates of a curve).

I want to read them in Matlab at once, save data and plot them.

Any suggestion?

Thank you

2 个评论
显示无隐藏无

Mitchell Thurston 2021-12-21

the second argument in xlsread is the sheet number, https://www.mathworks.com/help/matlab/ref/xlsread.html#bthgbma

you can either iterate through the sheet numbers in a loop, or just define the sheets you want to read. As far as I know, there isn't an automatically "read all of the sheets". hope this helps

Stephen23 2021-12-21

编辑：Stephen23 2021-12-21

Avoid using deprecated and discouraged XLSREAD.

For your task you should probably use READTABLE or READMATRIX.

Because you did not upload any sample files you make it much harder for people to write code for you and help you.

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-12-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1615435-read-and-process-multiple-sheets-from-excel-to-matlab#answer_859630

编辑：Stephen23 2021-12-21

在 MATLAB Online 中打开

Untested, but this should get you started:

P = 'absolute or relative path to where the files are saved';
F = 'filename.xlsx';
S = sheetnames(fullfile(P,F));
N = numel(S);
C = cell(1,N);
for k = 1:N
    C{k} = readtable(fullfile(P,F), 'Sheet',S(k));
end