Get Worksheets
Gets all the worksheets 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.
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
get the excel's worksheets
Last updated
Was this helpful?