Get the File's Sheets

📘
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

Concept	Description	Type	Required
`file`	The reference to the Excel file. The file must be an Excel file stored in a SharePoint document library.	`sharepoint file reference`	Yes

Output Concepts

Concept	Description	Type
`file's sheets`	The list of Excel sheets in the file.	`excel sheet reference`

Examples

Retrieve the sheets of an Excel file.

get the site from sharepoint whose name is "My Site"
get the site's document libraries
get the items from the first library
get the second item
use the above as the folder
get the folder's items
use the above as the responses
get the second response
use the above as the target
get the target's sheets

Retrieve the sheets of an Excel file by name.

get the site from sharepoint whose name is "My Site"
get the site's document libraries
get the items from the first library
get the second item
use the above as the folder
get the folder's items
use the above as the responses
get the second response
use the above as the target
get the target's sheets whose name is "Sheet1"