display more than thousands rows in Excel

["Monica Li" <lim odshp com>]

Hi all,

Is anyone knows why nothing displayed in Excel if there are a few hundreds
or thousands rows data. I have a xsp file which gets data from database, and
two different style sheets. one of the style sheet is xls style sheet which
displays data in Excel. If there are only about 20 rows, maybe a little more
rows, it works fine. But not hundreds or thousands rows. Anyone knows why?

The following are part of the stylesheet.

Thanks.
Monica



<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                              xmlns:sql="http://apache.org/cocoon/SQL/2.0";
                             xmlns:gmr="http://www.gnome.org/gnumeric/v7"; >

  <xsl:param name="view-source"/>

  <xsl:template match="PAGE">
   <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7";>
     <gmr:Sheets>
         <gmr:Sheet DisplayFormulas="false" HideZero="false"
HideGrid="false" HideColHeader="false" HideRowHeader="false"
DisplayOutlines="true" OutlineSymbolsBelow="true"
OutlineSymbolsRight="true">
                 <gmr:Name><xsl:value-of select="TITLE"/></gmr:Name>
                 <gmr:MaxCol>9</gmr:MaxCol>
                 <gmr:Cols DefaultSizePts="78">
                     <gmr:ColInfo No="0" Unit="78" MarginA="2" MarginB="2"/>
                 </gmr:Cols>
                 <gmr:Rows DefaultSizePts="12.8">
                        <gmr:RowInfo No="0" Unit="12.8" MarginA="0" MarginB="0"
Count="9"/>
                        <gmr:RowInfo No="10" Unit="12.8" MarginA="1" MarginB="0"
Count="2000"/>
                 </gmr:Rows>
                 <gmr:Cells>
                        <xsl:apply-templates/>
                 </gmr:Cells>
        </gmr:Sheet>
     </gmr:Sheets>
    </gmr:Workbook>
  </xsl:template>

   <xsl:template match="CLMNUMBER">
     <gmr:Cell Col="0" ValueType="60">
      <xsl:variable name="rownumber"><xsl:number level="any" from="content"
count="CLMNUMBER"/></xsl:variable>
      <xsl:attribute name="Row">
         <xsl:value-of select="$rownumber"/>
      </xsl:attribute>
      <gmr:Content>
                <xsl:apply-templates/>
        </gmr:Content>
     </gmr:Cell>
  </xsl:template>