Create table from excel spreadsheet with multiple sheets

Suppose I have xlsx file with multiple sheets. I want to create table A from the first sheet and create table B from the second sheet. Please advise.

Answer 1

[Image Analyst]

Try this:

folder = fileparts(which('patients.xls')) % Determine where demo folder is.
fullFileName = fullfile(folder, 'patients.xls');
[status, sheetNames] = xlsfinfo(fullFileName)
numSheets = length(sheetNames)
t1 = readtable(fullFileName, 'Sheet', 1)
t2 = readtable(fullFileName, 'Sheet', 2)

and so on. Put in a loop if you want.

[alpedhuez]

What will the first four lines do?

[dpb]

Try it and see???

Answer 2

[dpb]

See

doc readtable

[alpedhuez]

Is it like

readtable('patients.xls',...
    'Sheet',1,...)

?

[dpb]

That's certainly possible, yes...you're missing a LHS variable to assign the result to, however.