Yep. Your guess is right! You are overwrite the first with the second. You need to use a variable to move to the next row. As a solution, try to use JXTemplate.
Best Regards, Antonio Gallardo. On Mie, 26 de Enero de 2005, 6:04, Philipp Rech dijo: > Hello Cocooners, > > [Cocoon Version 2.1.6] > > i have the following xml file (see below) which is the result of a db > querry > (from Cocoon)... when i transfrom it with the stylesheet (see below) using > the > transfomer within Cocoon an excel sheet opens but with only one row in it > (the > one with the last id) but i need all elements in diferent rows... so only > the > last <row> element with the <eventid>2</eventid> gets displayed but not > both of > them... my guess was thet the first one is processed but is overwritten by > the > last one (see my xml and xsl file below) > > thank you very much! > phil > > ps: i already asekd on the poi-user list but > got no reply... > > > here is my xml file: > -------------------------------- > <?xml version="1.0" encoding="ISO-8859-1" ?> > <page> > <content> > <rowset xmlns:sql="http://apache.org/cocoon/SQL/2.0"; > xmlns="http://apache.org/cocoon/SQL/2.0";> > <row> > <eventid>3</eventid> > <typeofcontrol>Control Type A</typeofcontrol> > <trafficdirection>Entry</trafficdirection> > <checkpoint>Blue Border</checkpoint> > <klassification>illigal</klassification> > <checklocation>black sea</checklocation> > <guard_1>Philipp</guard_1> > <guard_2>Peter Pan</guard_2> > <objection>smug</objection> > <dtg>2005-01-01</dtg> > <location>black sea</location> > <description></description> > <numberofpersons>3</numberofpersons> > <observed>Yes</observed> > </row> > <row> > <eventid>2</eventid> > <typeofcontrol>Control Type B</typeofcontrol> > <trafficdirection>Leave/trafficdirection> > <checkpoint>Airport</checkpoint> > <klassification>illigal entry</klassification> > <checklocation>airport hall 2</checklocation> > <guard_1>Philipp</guard_1> > <guard_2>Stepht</guard_2> > <objection>illigal enrty</objection> > <dtg>2005-01-12</dtg> > <location>airport somewhere</location> > <description>none</description> > <numberofpersons>1</numberofpersons> > <observed>No</observed> > </row> > </rowset> > </content> > </page> > --------------------------------- > > > here is my xsl file: > > ----------------------------- > > <?xml version="1.0"?> > <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:template match="/"> > <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>BIHS - Event Data</gmr:Name> > <gmr:MaxCol>2</gmr:MaxCol> > <gmr:Cols DefaultSizePts="48"> > <gmr:ColInfo No="0" Unit="48" MarginA="2" MarginB="2" > Count="7"/> > </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="24"/> > </gmr:Rows> > <gmr:Cells> > <xsl:apply-templates/> > </gmr:Cells> > </gmr:Sheet> > </gmr:Sheets> > </gmr:Workbook> > </xsl:template> > > > > <xsl:template match="sql:eventid"> > <gmr:Cell Col="0" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > > <xsl:template match="sql:typeofcontrol"> > <gmr:Cell Col="1" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > > <xsl:template match="sql:trafficdirection"> > <gmr:Cell Col="2" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > > > <xsl:template match="sql:checkpoint "> > <gmr:Cell Col="3" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > > > > <xsl:template match="sql:klassification"> > <gmr:Cell Col="4" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > > > <xsl:template match="sql:guard_1"> > <gmr:Cell Col="5" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > <xsl:template match="sql:guard_2"> > <gmr:Cell Col="6" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > <xsl:template match="sql:objection"> > <gmr:Cell Col="7" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > <xsl:template match="sql:dtg"> > <gmr:Cell Col="8" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > <xsl:template match="sql:location"> > <gmr:Cell Col="9" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > <xsl:template match="sql:description"> > <gmr:Cell Col="10" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> <xsl:template match="sql:numberofpersons"> > <gmr:Cell Col="11" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> <xsl:template match="sql:observed"> > <gmr:Cell Col="12" ValueType="60"> > <xsl:variable name="rownumber"><xsl:number level="any" > from="content" > count="row"/></xsl:variable> > <xsl:attribute name="Row"> > <xsl:value-of select="$rownumber"/> > </xsl:attribute> > <gmr:Content> > <xsl:apply-templates/> > </gmr:Content> > </gmr:Cell> > </xsl:template> > > > > </xsl:stylesheet> > > > ---------------------------------- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
