List Sheets Activity
The List Sheets activity enables the extraction of all worksheet names from a specified Excel file. It then transfers these names into a new dataset, providing a structured list of the file's contents.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name of the Excel file that has already been opened or created. | Required |
| New dataset name | The reference name for the new dataset that will be created to store the sheet names. | Required |
Action Types & Examples
Dataset Output
- Format: A dataset object containing a collection of string values. Each string represents a worksheet name found in the specified Excel file.
- Example Result:
listDataset
Implementation Examples
Field Setup - Excel name: ${newExcel} - New dataset name: listDataset
Execution Parameters - Configure Excel name with the variable newExcel - Configure New dataset name with the literal value listDataset
Technical Notes
Ensure the referenced Excel file is open and accessible before executing this activity. If a dataset with the specified name already exists, it will be overwritten.