Get worksheet names action

The Get worksheet names action of the Excel advanced package enables you to get the names of all the worksheets and assign them to a list variable of string data type.

Settings

  • Enter the name of the session used to open the workbook with the Open action.
  • Select a string variable that you want to use to store the name of the worksheet from the Assign the output to variable list. The Control Room shows a descriptive default variable name. If you create several output variables, subsequent variable names are appended with a -1, -2, -3, and so on to avoid duplication.