Respective matrices for different sheets in imported file frin excel

1 次查看（过去 30 天）
JL
JL 2020-6-3
评论： JL 2020-6-3
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
Use the 'sheet' option like shown here: https://de.mathworks.com/help/matlab/ref/readtable.html#d120e1047964
contentTable = readtable(filename,'sheet',2);
uniqueTable = readtable(filename,'sheet',3);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by