Respective matrices for different sheets in imported file frin excel

1 次查看(过去 30 天)
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);

采纳的回答

Stephan
Stephan 2020-6-3
编辑:Stephan 2020-6-3
contentTable = readtable(filename,'sheet',2);
uniqueTable = readtable(filename,'sheet',3);

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by