Get multiple cells action

The Get multiple cells action in the Excel basic package enables you to retrieve the values from cells in a Microsoft Excel spreadsheet and stores 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.
  • Select any of the following options from the Loop through field:
    Option Action
    All rows: Enables you to retrieve the values from all the rows.
    Specific row: Enables you to retrieve the values from the row you have specified in the From row and to row fields.
    Cell range: Enables you to retrieve the values from the range of cells you have specified in the From cell and to cell field.
  • Enter the name of the session used to open the workbook with the Open action.
  • In the Get value to the variable (optional) field, create or insert an existing string variable.