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.

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".
Variable

The variable to store the generated HTML table in.