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"

Last updated

Was this helpful?