5 XSLT Modules

The xtpxlib-xoffice component contains the following XSLT modules.

Module/Pipeline	Description
`excel-conversions.mod.xsl`	Excel data specific conversions
`xoffice.mod.xsl`	Library with support code for the MS Office file handling.

5.1 XSLT (3.0): `excel-conversions.mod.xsl`

File: xslmod/excel-conversions.mod.xsl

Excel data specific conversions

Prefix	Namespace URI
`xtlxo`	`http://www.xtpxlib.nl/ns/xoffice`

Variable	Type	Value	Description
`xtlxo:excel-start-date`	`xs:date`	`xs:date('1900-01-01')`

Function	Description
`xtlxo:excel-date-to-xs-date()`	Converts an Excel date integer into an xs:date.
`xtlxo:xs-date-to-excel-date()`	Converts an xs:date into an Excel date integer.

5.1.1 Function: `xtlxo:excel-date-to-xs-date() as xs:date`

Converts an Excel date integer into an xs:date.

Parameter	Type	Description
`excel-value`	`xs:integer`	The Excel date integer to convert.

5.1.2 Function: `xtlxo:xs-date-to-excel-date() as xs:integer`

Converts an xs:date into an Excel date integer.

Parameter	Type	Description
`date`	`xs:date`	The xs:date to convert.

5.2 XSLT (2.0): `xoffice.mod.xsl`

File: xslmod/xoffice.mod.xsl

Library with support code for the MS Office file handling.

Depends on the following XSLT modules from the xtpxlib-common component:

general.mod.xsl
href.mod.xsl

Yet largely undocumented. Use at your own risk.

Prefix	Namespace URI
`xtlxo`	`http://www.xtpxlib.nl/ns/xoffice`

Variable	Type	Value
`xtlxo:relationship-type-comments`	`xs:string`	`'http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments'`
`xtlxo:relationship-type-core-properties`	`xs:string`	`'http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties'`
`xtlxo:relationship-type-custom-properties`	`xs:string`	`'http://schemas.openxmlformats.org/officeDocument/2006/relationships/custom-properties'`
`xtlxo:relationship-type-extended-properties`	`xs:string`	`'http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties'`
`xtlxo:relationship-type-main-document`	`xs:string`	`'http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument'`
`xtlxo:relationship-type-shared-strings`	`xs:string`	`'http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings'`

Named template	Description
`xtlxo:get-properties`

Function	Description
`xtlxo:doc-href()`
`xtlxo:get-file-root()`
`xtlxo:get-file-root-from-relationship-id()`
`xtlxo:get-file-root-from-relationship-type()`
`xtlxo:get-file-root-relationship()`
`xtlxo:get-href()`
`xtlxo:get-rels-href()`

5.2.1 Named template: `xtlxo:get-properties`

Parameter	Type	Rq?	Default	Description
`extracted-office-xml`	`element(xtlcon:document-container)`

5.2.2 Function: `xtlxo:doc-href() as xs:string`

Parameter	Type	Description
`href-parts`	`xs:string+`

5.2.3 Function: `xtlxo:get-file-root() as element()?`

Parameter	Type	Description
`extracted-office-xml`	`element(xtlcon:document-container)`
`href-parts`	`xs:string+`
`is-mandatory`	`xs:boolean`

5.2.4 Function: `xtlxo:get-file-root-from-relationship-id() as element()?`

Parameter	Type	Description
`extracted-office-xml`	`element(xtlcon:document-container)`
`basefile-href`	`xs:string`
`relationship-id`	`xs:string`
`is-mandatory`	`xs:boolean`

5.2.5 Function: `xtlxo:get-file-root-from-relationship-type() as element()?`

Parameter	Type	Description
`extracted-office-xml`	`element(xtlcon:document-container)`
`basefile-href`	`xs:string`
`relationship-type`	`xs:string`
`is-mandatory`	`xs:boolean`

5.2.6 Function: `xtlxo:get-file-root-relationship() as element(mso-rels:Relationships)?`

Parameter	Type	Description
`extracted-office-xml`	`element(xtlcon:document-container)`
`basefile-href`	`xs:string`
`is-mandatory`	`xs:boolean`

5.2.7 Function: `xtlxo:get-href() as xs:string`

Parameter	Type	Description
`elm`	`element()`

5.2.8 Function: `xtlxo:get-rels-href() as xs:string`

Parameter	Type	Description
`basefile-href`	`xs:string`

5 XSLT Modules

5.1 XSLT (3.0): excel-conversions.mod.xsl

5.1.1 Function: xtlxo:excel-date-to-xs-date() as xs:date

5.1.2 Function: xtlxo:xs-date-to-excel-date() as xs:integer

5.2 XSLT (2.0): xoffice.mod.xsl

5.2.1 Named template: xtlxo:get-properties

5.2.2 Function: xtlxo:doc-href() as xs:string

5.2.3 Function: xtlxo:get-file-root() as element()?

5.2.4 Function: xtlxo:get-file-root-from-relationship-id() as element()?

5.2.5 Function: xtlxo:get-file-root-from-relationship-type() as element()?

5.2.6 Function: xtlxo:get-file-root-relationship() as element(mso-rels:Relationships)?

5.2.7 Function: xtlxo:get-href() as xs:string

5.2.8 Function: xtlxo:get-rels-href() as xs:string