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.

注： 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.

Automation 360