Add AutoFilter to Excel generated by XSLT/XXML? (Xml to Excel with autofilter)

See more:

XML

XSLT

MS-Excel

Hello!

I have an xslt and I have an excel file with format. I need to add an autofilter to the second row which has the table headers.

I've tried adding

<x:autofilter x:range="R2C1:R2C5" xmlns:x="#unknown"></x:autofilter>

as described by XML Excel Reference, but it's not working.

I hope you can help.

This is the code with the table I want to be autofiltered.

<ss:worksheet ss:name="User Rpt DYNDB - Header" xmlns:ss="#unknown">


  <ss:table>

     <xsl:variable name="request" xmlns:xsl="#unknown">
select="/IDVMerge/IDVRoot/Info[Name='req.INFO.dyntable.header.2']"
/&gt;

           <xsl:for-each select="$request/../ResultSetMetaData/Column">
              <ss:column ss:autofitwidth="1" ss:width="115" />
           </xsl:for-each>

     <ss:row ss:autofitheight="0" ss:height="26.0">
        <ss:cell ss:styleid="pageTitle">
          <ss:data ss:type="String">
                    DBF#2   H E A D E R
          </ss:data>
        </ss:cell>
     </ss:row>

        <ss:row>
              <xsl:for-each>
select="$request/../ResultSetMetaData/Column/Name"&gt;
                 <ss:cell ss:styleid="tableHeader">
                    <ss:data ss:type="String"><xsl:value-of>
select="."/&gt;</xsl:value-of></ss:data>
                 </ss:cell>
              </xsl:for-each>
        </ss:row>

           <xsl:for-each select="$request/../ResultSet/Row">
              <ss:row>
                 <xsl:for-each select="Column">
                 <xsl:choose><xsl:when test="@col='0'">
                    <ss:cell ss:styleid="tableCellRightBold">
                       <ss:data ss:type="String"><xsl:value-of>
select="."/&gt;</xsl:value-of></ss:data>
                    </ss:cell>
                 </xsl:when><xsl:otherwise>
                    <ss:cell ss:styleid="tableCell">
                       <ss:data ss:type="String"><xsl:value-of>
select="."/&gt;</xsl:value-of></ss:data>
                    </ss:cell></xsl:otherwise></xsl:choose>
                 </xsl:for-each>
              </ss:row>
           </xsl:for-each>

           <ss:row /><ss:row />


  </xsl:variable></ss:table>

        <xsl:call-template name="lib_styles_adv" xmlns:xsl="#unknown"></xsl:call-template>


</ss:worksheet>