Get Sheet Names
Use this action to capture all sheet names from an existing workbook.
Step 1. Create a process and give it a name.
Step 2. Drag the Get Sheet Names action to the canvas and link it to the other actions.
Step 3. Create the variables needed for the configuration of the action, and then add them to the configuration panel:
- Excel workbook: you need to enter the workbook file from which all the sheet names will be extracted
- Sheet names: the output contains a variable of type list<string> which will store the sheet names
Step 4. Save, Validate and Run the process.
Step 5. You will be prompted to add the excel file for the input variable. Click Run.
Step 6. To verify the process click Check instance.
Step 7. In the Output section, you can see the list with sheet names: