本文介绍了将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']"
/&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>

推荐答案




这篇关于将AutoFilter添加到XSLT/XXML生成的Excel吗? (从Xml到带有自动过滤器的Excel)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

05-28 21:57
查看更多