Extract As HTML
The Extract As HTML action extracts a part of a spreadsheet document as an HTML table and stores it in a variable.
The range finder of the step determines what is extracted and this may be either a part of a single sheet or
all the information properties.
The Extract Cell action can be configured using the following properties:
- Include Headers:
This property specifies whether or not to include the spreadsheet headers (1,2,3,4 and A,B,C,D, etc.) in
the generated table.
- Extract This:
This specifies what is extracted from the cells, but have no effect for extraction of information properties.
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".
The variable to store the generated HTML table in.