Respective matrices for different sheets in imported file frin excel

3 Ansichten (letzte 30 Tage)
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);

Akzeptierte Antwort

Stephan
Stephan am 3 Jun. 2020
Bearbeitet: Stephan am 3 Jun. 2020
contentTable = readtable(filename,'sheet',2);
uniqueTable = readtable(filename,'sheet',3);

Weitere Antworten (0)

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by