Get multiple cells action

The Get multiple cells action in the Excel advanced package enables you to retrieve the values from the cells in a Microsoft Excel spreadsheet and store them in a table variable.

Settings

This action retrieves cell values as string data types. It supports Excel cell formats, including Number, Percentage, Currency, Scientific, and Date. For example, a value from a cell of Currency formatting retains the currency symbol when passed to a table or record variable.
Note: You must convert the values to perform non-string operations.
  • Use the Select range of cells to be returned drop-down to select one of the following options:
    • All rows: Select one of the following options under Read options:
      • Read visible text in cell: cell value is read as is.
      • Read cell value: formatting is ignored while reading the cell value.

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

        Recommendation: Use the Read cell value option as the reading value for a better performance than reading visible text.
    • Specific rows: Use the following fields to specify the rows:
      • From row
      • to row
    • Cell range: Use the following fields to specify the range for cells:
      • From cell
      • To cell
  • Enter the name of the session used to open the workbook with the Open action.
  • Select a table variable to store the retrieved values in the Assign value to 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.