Get Worksheets
Gets all worksheet from an Excel workbook.
Overview
This procedure retrieves all the worksheets in an Excel workbook. Once retrieved, these can be used for further processing. For example, your automation can loop through the list of worksheet names to extract data, apply transformations, or generate reports as needed.
This procedure is not recommended for large Excel files. For large files, it is recommended to use Get a Worksheet instead.
Prerequisite Data
These required data elements must be present in the automation before using the procedure.
Data Name
Data Type
the excel
Excel File
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Get the Excel's Worksheets
Last updated
Was this helpful?