Get table range action

The Get table range action in the Excel advanced package enables you to get the range of a table available in a worksheet and store the output in a string variable.

Settings

  • Specify the Table name for which you want to get the range.
    Note: The table name is a string value and NOT a data table name. For information on how to retrieve the Excel table name, see Rename an Excel table.
  • Select the options to specify whether you want to include a header and pivot table in the range and a variable to store the output. 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.
  • Enter the name of the session used to open the workbook with the Open action.