Retrieve sheet count action in Microsoft 365 Excel

The Retrieve sheet count action in the Microsoft 365 Excel package enables you to get the number of sheets available in the current workbook and stores 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.