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.
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".
An optional list of
data converters that should process the
The variable to assign the value to.