Retrieve sheets count action

The Retrieve sheets count action of the Excel advanced package enables you to get the number of sheets available in the current workbook and store it in a number variable.

Settings

  • Select the appropriate option to specify whether to include the hidden worksheet or not and assign the count to a variable.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select a number variable that you want to use to store the name of the worksheet from the Select the variable to assign to 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.