本文介绍了将AutoFilter添加到XSLT/XXML生成的Excel吗? (从Xml到带有自动过滤器的Excel)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好!
我有一个xslt,并且我有一个具有格式的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>
如XML Excel Reference中所述,但它不起作用.
希望您能提供帮助.
这是带有我要自动过滤的表的代码.
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']"
/>
<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">
<ss:cell ss:styleid="tableHeader">
<ss:data ss:type="String"><xsl:value-of>
select="."/></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="."/></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="."/></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>
推荐答案
这篇关于将AutoFilter添加到XSLT/XXML生成的Excel吗? (从Xml到带有自动过滤器的Excel)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!