Read row action

The Read row action in the Excel advanced package enables you to extract data from a row and stores it in a list variable of string data type.

Settings

Extracts data from a row and stores it in a list variable of string data type.

  • Select the From active cell or From specific cell option to specify the starting point.

    (Optional) Select the Read full row option to extract data for the entire row.

  • 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.

    For more information, see Using the Open action.

  • Select a list variable of string data type that you want to use to store the extracted values. 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.