Get single cell action
- Updated: 2022/11/29
Get single cell action
The Get single cell action in the Excel advanced package enables you to retrieve the values from a single cell in a Microsoft Excel spreadsheet or a CSV file and store them in a string 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 the Active cell option to retrieve the value from the active cell, or select Specific cell to retrieve the value from a specific cell in a Microsoft Excel spreadsheet.
- 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%.
Recommendation: Use the Read cell value option as the reading value from a cell 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 string variable to store the retrieved values in the Store cell contents to 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.
Note: If the character limit in a
single cell of a Microsoft Excel spreadsheet exceeds 8200,
then the bot reads only the first 8200
characters. This behaviour is specific only to Microsoft
Excel spreadsheet.
Example of using a conditional statement
.