Respective matrices for different sheets in imported file frin excel

1 visualizzazione (ultimi 30 giorni)
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);

Risposta accettata

Stephan
Stephan il 3 Giu 2020
Modificato: Stephan il 3 Giu 2020
contentTable = readtable(filename,'sheet',2);
uniqueTable = readtable(filename,'sheet',3);

Più risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by