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)

Community Treasure Hunt

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

Start Hunting!