Read and process multiple sheets from Excel to Matlab

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

[Mitchell Thurston]

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]

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]

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

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-cell-array.html

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html