Get the File's Sheets
Retrieve the sheets of an Excel file.
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?