Get multiple cells action
- Updated: 2022/11/17
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.