Overview
This article describes how to convert from XSL–FO to an Excel Spreadsheet.
Administration
Converting XSL–FO to an Excel Spreadsheet
-
Remove Excel Gridlines from the output by adding the following to the worksheet options:
<x:DoNotDisplayGridLines>true</x:DoNotDisplayGridLines>
-
Set the default Zoom level of the spreadsheet by adding the following to the worksheet options (in this example, 75%):
<x:Zoom>75</x:Zoom>
-
Preserve Rich Text Attribute formatting on the Excel output. The value of the Rich Text attribute stored in the Document XML will be something like:
<p><em>Quo usque tandem abutere, Catalina, patienta nostra?</em><p>
<p><strong><u>Quam diu etiam furor iste tuus nos eludet?</u></strong></p>
<p><strong><u><em>Quem ad fidenm sese effrenata iactabit audacia?</em></u></strong></p>
The attribute's data is not enclosed in CDATA when being used for Printer Friendly/History XSL documents. (However, this is not true for Integration XSLs). Thus, you can import the rich text attribute and treat it like a node set, and use XPath functions and expressions to traverse its contents. For example:
<xsl:value-of select="$main_doc/richTextAttribute_quote/p[1]/em"/> => Quo usque tandem abutere, Catalina, patienta nostra?
There are three templates for parsing Bold, Italic, and Underlined text from a Rich Text Attribute:
-
Bold
<xsl:template match="strong" xmlns="http://www.w3.org/TR/REC-html40">
<B><xsl:apply-templates/></B>
</xsl:template>
-
Italic
<xsl:template match="em" xmlns="http://www.w3.org/TR/REC-html40">
<I><xsl:apply-templates/></I>
</xsl:template>
-
Underlined
<xsl:template match="u" xmlns="http://www.w3.org/TR/REC-html40">
<U><xsl:apply-templates/></U>
</xsl:template>
The internal call to <xsl:apply-templates> ensures that templates are called recursively on the input to each template, until no more templates are found matching any nested nodes (for example, plain text).
The XML namespace declaration is required within the scope of where the Excel XML tags (<B>, <U>, <I>) are being used. In this case, they are being used inside templates. If they are being hard-coded into a <Data> attribute, the XML namespace must be declared there as well.
For example:
<Data ss:Style="aStyle" xmlns="http://www.w3.org/TR/REC-html40">
<Cell>
<B>This is bold text</B>
<B><U>This is bold and underlined text</U></B>
</Cell>
</Data>
The above templates can then be called using the <xsl:apply-templates> element:
<Data>
<Cell>
<xsl:apply-templates select="$main_doc/richTextAttribute_quote/*"/>
</Cell>
</Data>
See Also
