Respective matrices for different sheets in imported file frin excel

1 view (last 30 days)
I have 3 sheets in the 'scheduling.xlsx', with roomTable(sheet 1), contentTable (sheet 2), uniqueTable(sheet 3)
filename = 'scheduling.xlsx';
roomTable = readtable(filename)
Using the code above, I can only see roomTable but not the rest when I use this method
contentTable = readtable(filename,2);
uniqueTable = readtable(filename,3);

Accepted Answer

Stephan
Stephan on 3 Jun 2020
Edited: Stephan on 3 Jun 2020
contentTable = readtable(filename,'sheet',2);
uniqueTable = readtable(filename,'sheet',3);

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!