Importing data from an Excel file with multiple tabs

2023 4 14
2 个回答
回答已采纳
更新时间：2023 4 14
32 次查看（30 天）

1 个投票

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?

请先登录，再回答此问题。

 采纳的回答

Cris LaPierre
Cris LaPierre 2023-4-14

1 个投票

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"

更多回答（1 个）

Walter Roberson
Walter Roberson 2023-4-14

1 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by