2022 June Release

Struct FSCPOI@1.1001:TableData Permanent link for this heading

Table definition. The alt text of a table is used as a key for updating existing tables. In case of updates, each table cell of the template table must not be empty. The first row is interpreted as the header, the second row is interpreted as data. Different styles for header and data rows are possible. If ignoreifmissing is set to true no new table will be created if an existing table cannot be found.

Properties Permanent link for this heading

Type

Property

Name

string

alternativetext

Alt Text

boolean

ignoreifmissing

Ignore missing Element

string

leaverep

Leave cell as is

string

newalternativedescription

New Alt Description

string

newalternativetext

New Alt Text

string

nullrep

Null Value

boolean

protectheader

Protect the Header

SheetRow[]

rows

Rows

integer

skiprows

Number of rows to be skipped

Properties Permanent link for this heading


Alt Text (FSCPOI@1.1001:alternativetext) Permanent link for this heading

string FSCPOI@1.1001:alternativetext


Ignore missing Element (FSCPOI@1.1001:ignoreifmissing) Permanent link for this heading

If set to true no error occurs if no format can be found.

boolean FSCPOI@1.1001:ignoreifmissing


Leave cell as is (FSCPOI@1.1001:leaverep) Permanent link for this heading

String used to indicate that a cell should be left as is.

string FSCPOI@1.1001:leaverep


New Alt Description (FSCPOI@1.1001:newalternativedescription) Permanent link for this heading

string FSCPOI@1.1001:newalternativedescription


New Alt Text (FSCPOI@1.1001:newalternativetext) Permanent link for this heading

string FSCPOI@1.1001:newalternativetext


Null Value (FSCPOI@1.1001:nullrep) Permanent link for this heading

This string is the NULL representation for a value within a cell. When this string is used, a cell value is considered NULL and left blank. e.g. "null", "NULL", "empty", ...

string FSCPOI@1.1001:nullrep


Protect the Header (FSCPOI@1.1001:protectheader) Permanent link for this heading

protectheader - if enabled, automatically skips the header line in tables

boolean FSCPOI@1.1001:protectheader


Rows (FSCPOI@1.1001:rows) Permanent link for this heading

unique SheetRow[] FSCPOI@1.1001:rows


Number of rows to be skipped (FSCPOI@1.1001:skiprows) Permanent link for this heading

skiprows is the number of rows to be skipped from the beginning of the table. E.g. it can be used to skip a row containing column headers.

unsigned integer FSCPOI@1.1001:skiprows