means the Brunner CMS 4 allows a dynamic document using content from the CMS database (eg customer addresses from the shop) dynamically into a Microsoft Excel document . Export
That is, the exported Excel file is always matched against the current contents of the CMS database, which now means the customer can simply download link. Here, the technologies of the Brunner CMS get yourself in XSLT and XML are used which generate the required Excel format. The following setting must be considered in the XSLT, so after the customer-generated and custom Excel file is created:
: \u0026lt;? Xml version = "1.0" encoding = "UTF-8"?>
\u0026lt; ; xsl: stylesheet version = "1.0" xmlns: xsl = "http://www.w3.org/1999/XSL/Transform" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
<xsl:output method="xml" media-type="application/vnd.ms-excel" />
<xsl:template match="/">
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<LastAuthor>Brunner CMS 4.0</LastAuthor>
<Version>1.00</Version>
</DocumentProperties>
[...]
<xsl:for-each select="/root/loops/loop[@keyname='kundenanfragen']/item">
<Row ss:Height="25" ss:StyleID="s106">
<Cell ss:StyleID="s101">
<Data ss:Type="Number">
<xsl:value-of select="data/@pointer_id" />
</Data>
</Cell>
<Cell ss:StyleID="s102">
<Data ss:Type="String">
<xsl:value-of select="data/produkt" />
</Data>
</Cell>
</Row>
\u0026lt;/ xsl: for-each>
[...]
