Switch to sheet action

The Switch to sheet action enables you to activate the specified worksheet from the selected Microsoft Excel file.

Settings

  • Double-click or drag the Switch to sheet action from the Excel advanced package in the Actions palette.
  • Use the Activate sheet by field to select one of the following options:
    • Index: to specify the number of the worksheet from which you want to get the number of rows.

      Ensure that the number is not 0 as the worksheet numbers start from 1.

    • Name:: to specify the name of the worksheet from which you want to get the number or rows.
  • Use the Session name field to select one of the following tabs:
    • Session name: Enter the name of the session used to open the workbook with the Open action.
    • Variable: Enter the Excel advanced session variable that you have created.
  • Click Save.
Note: The bot containing the Switch to sheet action switches to the hidden worksheet and performs operations on it. After the operations are completed, the worksheet remains hidden and is not activated.