Get single cell action

The Get single cell action in the Excel basic package enables you to retrieve the values from a single cell in a Microsoft Excel spreadsheet and stores 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 or Specific cell option to specify whether to retrieve the values from the active cell or a specific cell.
  • Enter the name of the session used to open the workbook with the Open action.
  • In the Store cell contents to field, create or insert an existing string variable.

You can use the output value to

Example of using a conditional statement

.