Get the Sheet's Tables

Retrieve the tables of an Excel sheet.

📘

Note: This operation is part of the Excel Book (BDK). To use this book, you need to first learn it in your agent.

Input Concepts

ConceptDescriptionTypeRequired
sheetThe reference to the Excel sheet.excel sheet referenceYes

Output Concepts

ConceptDescriptionType
sheet's tablesThe list of Excel tables in the sheet.excel table reference

Examples

Retrieve the tables of an Excel sheet.

get the first sheet
use the above as the sheet
get the sheet's tables

Retrieve the tables of an Excel sheet by name.

get the first sheet
use the above as the sheet
get the sheet's tables whose name is "Table1"