Get the File's Sheets

Retrieve the sheets of an Excel file.

This procedure is part of the Excel Book (BDK). To use this book, you must 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"