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

.