audit report.xslt

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>

<xsl:template match="/">
<xsl:apply-templates select="Data"/>

</xsl:template>

<xsl:template match="Data">

<xsl:processing-instruction name="mso-application">progid="Excel.Sheet"</xsl:processing-instruction>

<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">
<Styles>
<Style ss:ID="s24">
<Interior ss:Color="#083eb8" ss:Pattern="Solid"/>
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Font ss:Bold="1" ss:Color="#ffffff"/>

</Style>
</Styles>

<Worksheet ss:Name="Audit Report Data" >
<Table x:FullColumns="1" x:FullRows="1">
<Column ss:Width="250.25"/>
<Column ss:Width="100"/>
<Column ss:Width="150.5"/>
<Column ss:Width="113.25"/>
<Column ss:Width="110.25"/>
<!--<Row >
<xsl:for-each select="//Fiscal[last()]//FiscalData">

<Cell ss:StyleID="s24">
<Data ss:Type="String">
<xsl:value-of select="@Title"/>
</Data>
</Cell>
</xsl:for-each>
</Row>-->
<xsl:for-each select="Fiscal">
<Row>
<xsl:for-each select="FiscalData">

<Cell >
<Data ss:Type="String">
<xsl:value-of select="text()" />
</Data>
</Cell>
</xsl:for-each>
</Row>
</xsl:for-each>

</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<Print>

<ValidPrinterInfo/>

<HorizontalResolution>600</HorizontalResolution>

<VerticalResolution>600</VerticalResolution>

</Print>

<Selected/>

<Panes>

<Pane>

<Number>3</Number>

<ActiveRow>12</ActiveRow>

<ActiveCol>1</ActiveCol>

</Pane>

</Panes>

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>
</Workbook>
</xsl:template>
</xsl:stylesheet>