Extract Cell

The Extract Cell action extracts content from a spreadsheet document, runs it through a list of data converters, and stores the result into a variable.

Properties

The Extract Cell action can be configured using the following properties:

Extract This

This specifies what is extracted from the cell. There are three possible choices:

  • "Formatted Values" specifies that the formatted should be extracted, e.g. numbers will be extracted as the view shows these and not the internal representation with extra decimal point.
  • "Plain Values" specifies that the internal representation is extracted, e.g. numbers are extracted with full precision and dates are extracted as number of days since January 1, 1900. Cells for which there are no difference between formatted and plain values, e.g. cells containing text or logical values, the extracted values are the same as for "Formatted Values".
  • "Formulas" specifies that the formulas should be extracted. For cells that do not contain a formula the extracted values are the same as for "Plain Values".
Converters

An optional list of data converters that should process the content.

Variable

The variable to assign the value to.