Skip to content

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, making them available for subsequent automation steps.

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

Excel File Reference

  • Format: string
  • Example Result: newExcel

Dataset Name

  • Format: string
  • Example Result: listDataset

Implementation Examples

Field Setup - Excel name: newExcel - New dataset name: listDataset

Execution Parameters - Excel name: newExcel - New dataset name: listDataset

Technical Notes

The activity creates a new dataset. If a dataset with the specified New dataset name already exists, it will be overwritten. Ensure the referenced Excel file is open and accessible before executing this activity.