row-oriented-headers

A sheet-level hint telling the extractor that the template worksheet's tables are laid out with their headers on rows — i.e. the tables are stacked vertically, one below another, and each record is a row.

pebblestream:row-oriented-headers

Without either orientation hint the extractor tries both orientations and keeps
whichever matches more of the worksheet's expected headers. Use this directive
when the template's layout is ambiguous (for example when the header words also
appear as data values) and the automatic choice would be wrong.

Syntax

pebblestream:row-oriented-headers

No arguments.
Placed on any cell of the worksheet.
Requires template-name on the same worksheet.
Mutually exclusive with column-oriented-headers.

Example

A template with two stacked tables:

        A          B        C
1   Domestic
2   Item         Qty      Price
3   Widget       10       2.50
4   Gadget       3        7.00
5
6   International
7   Item         Qty      Price
8   Sprocket     5        4.10

The pebble's input sheet declares:

pebblestream:template-name:Template
pebblestream:row-oriented-headers

so the extractor reads records downward from each header row instead of treating
the columns as records.

Errors

Error	Cause
`dir-too-many-args`	Arguments were supplied.
`incompatible-template-directives`	`column-oriented-headers` is also present on the sheet.
`missing-the-template-name-directive`	The sheet has no `template-name`.

Template directives — the extraction algorithm
column-oriented-headers — the opposite orientation
block-id — identify which stacked table a row came from

Updated about 9 hours ago

Did this page help you?

Syntax

Example

Errors

Related