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 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 the Multiple cells option to retrieve values from a range of cells, or select All cells to retrieve values from all the cells.
注： When you run a bot with the Excel Advanced > Cell range option, ensure that you use a numeric value as the last character in the From cell and To cell fields (for example, testa1). The last character cannot be an alpha character.
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%.

注： When you use the Read visible text option to process large data sets in Microsoft Excel spreadsheets, the action consumes more time to process the data.

Recommendation： Use the Read cell value option as the reading value for a better performance than reading visible text.
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.

Automation 360