Thet Get worksheet as data table action of the Excel advanced package enables you to get data from a worksheet and save it to a table variable.

Settings

  • Specify either an index number in the Sheet by Index field or a name in the Sheet by Name field for the worksheet. The index number is the number assigned to a worksheet. For example, if you want to perform an operation on the worksheet at the third position in the workbook, enter 3 in the field.
  • Choose from the Read option to read either the visible text or value of the cell.

    For example, if the cell has 70% as cell content, Read cell value option will read the value as 70 ignoring the % format whereas Read visible text option will read the content as 70%.

    Recommendation: Use option Read cell value as reading value from a cell gives better performance than reading a visible text.
  • Enter the name of the session used to open the workbook with the Open action.
  • Select a table variable that you want to use to store the data from the worksheet from the Assign value to the 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.