Importing data from an Excel file with multiple tabs

I have an Excel file that I would like to pull data from, except it has multiple tabs and I have to use the command 'readtabe' to import the data because it is a mixture of different variable types. How can I specify which tab to pull data from?

Answer 1

[Cris LaPierre]

Use the 'Sheet' name-value pair to indicate which sheet to read the data from. Documented here: https://www.mathworks.com/help/matlab/ref/readtable.html#mw_0a3219fd-d40a-46a9-b230-7e249002f7b1

• Example: 'Sheet', 2
• Example: 'Sheet', 'MySheetName'
• Example: 'Sheet', "MySheetName"

Answer 2

[Walter Roberson]

filename = 'AsAppropriate.xlsx';

T1 = readtable(filename, 'Sheet', 3);   %can give sheet index
T2 = readtable(filename, 'Sheet', 'partslist');  %can give sheet name