Get Sheets
Gets all the worksheets from a specified workbook.
Last updated
Gets all the worksheets from a specified workbook.
Last updated
This activity retrieves all the sheets from a user-specified workbook using the Microsoft Graph Get worksheet API.
Connection Id: GraphServiceClient Variable Required
Specifies the office 365 connection id.
Workbook: Object Argument Required
Specifies the DriveItem of the Excel workbook whose sheets are to be retrieved. We can also specify the output variable of the Find Files And Folders activity (which is First or Results) directly as input in this property or use the output variable of the Create Workbook activity (Workbook). If we are using the Results property of the Find Files And Folders activity then we can directly specify the element in the array.
For example : Results[1].
Workbook:Array Variable
Specifies the sheets from a given workbook as a String array.\
