You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Philipp Rech <re...@iuw.fh-darmstadt.de> on 2005/01/26 13:04:37 UTC
transformation from XML to excel only works with one element set
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: transformation from XML to excel only works with one element
set
Posted by Jan Hoskens <jh...@schaubroeck.be>.
You might want to try this:
<gmr:Cells>
<xsl:apply-templates select="page/content/rowset/row">
<xsl:with-param name="rowposition" select="position()"/>
</xsl:apply-templates>
</gmr:Cells>
and then use <xsl:param name="rowposition"/> where you need to set Row="" instead of re-counting
your rows every time. Also this: you might want to set your Row directly through a shortcut:
<gmr:Cell Row="{$rowposition}"> as the content of {} will be evaluated by xsl.
<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>
>
Didn't try this myself but think this might work.
Kind Regards,
Jan
Philipp Rech wrote:
> 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: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: transformation from XML to excel only works with one element set
Posted by Philipp Rech <re...@iuw.fh-darmstadt.de>.
jxtg? okay, but i need microsoft excel as and ouput format and
i do't see how JXTG could help me here...
i would need one excel-row for each row element...
i was thinking that i miss a <xsl:for-each ...> instruction
but i dunno where/how to apply this...
(the transformation works fine to WML and PDF btw)
any hints? (stylesheet > see below)
thanks a lot!
philipp
> 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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: [SOLVED] transformation from XML to excel only works with one element set
Posted by Philipp Rech <re...@iuw.fh-darmstadt.de>.
Hello,
thank you Jan it works! Here is my new stylesheet
maybe it is usefull for someone...
bye now!
philipp
-------------------------------------------------
<?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>
<gmr:SheetNameIndex>
<gmr:SheetName>BIHS-Reporting-Events</gmr:SheetName>
</gmr:SheetNameIndex>
<gmr:Sheets>
<gmr:Sheet>
<gmr:Name>BIHS-Reporting-Events</gmr:Name>
<gmr:Styles>
<gmr:StyleRegion startRow="0" endRow="0" startCol="0" endCol="99">
<gmr:Style HAlign="8" VAlign="4" WrapText="1" Orient="1" Shade="0"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF"
PatternColor="0:0:0" Format="General">
<gmr:Font Unit="10" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">
Helvetica
</gmr:Font>
</gmr:Style>
</gmr:StyleRegion>
</gmr:Styles>
<gmr:Cells>
<xsl:call-template name="headerrow"/>
<xsl:apply-templates select="/page/content/sql:rowset/sql:row"/>
</gmr:Cells>
</gmr:Sheet>
</gmr:Sheets>
</gmr:Workbook>
</xsl:template>
<xsl:template name="headerrow">
<gmr:Cell Row="0" Col="0" ValueType="60">Event ID</gmr:Cell>
<gmr:Cell Row="0" Col="1" ValueType="60">Type of Control</gmr:Cell>
<gmr:Cell Row="0" Col="2" ValueType="60">Traffic Direction </gmr:Cell>
<gmr:Cell Row="0" Col="3" ValueType="60">Check Point</gmr:Cell>
<gmr:Cell Row="0" Col="4" ValueType="60">Classification</gmr:Cell>
<gmr:Cell Row="0" Col="5" ValueType="60">Location of crime</gmr:Cell>
<gmr:Cell Row="0" Col="6" ValueType="60">1'th Guard</gmr:Cell>
<gmr:Cell Row="0" Col="7" ValueType="60">2'nd Guard</gmr:Cell>
<gmr:Cell Row="0" Col="8" ValueType="60">Objection</gmr:Cell>
<gmr:Cell Row="0" Col="9" ValueType="60">Date</gmr:Cell>
<gmr:Cell Row="0" Col="10" ValueType="60">Location of crime</gmr:Cell>
<gmr:Cell Row="0" Col="11" ValueType="60">Description</gmr:Cell>
<gmr:Cell Row="0" Col="12" ValueType="60">Nr. of Persons</gmr:Cell>
<gmr:Cell Row="0" Col="13" ValueType="60">Observed by guard</gmr:Cell>
</xsl:template>
<xsl:template match="sql:row">
<xsl:variable name="row" select="position()"/>
<gmr:Cell Row="{$row}" Col="0" ValueType="60">
<xsl:value-of select="sql:eventid"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="1" ValueType="60">
<xsl:value-of select="sql:typeofcontrol"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="2" ValueType="60">
<xsl:value-of select="sql:trafficdirection"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="3" ValueType="60">
<xsl:value-of select="sql:checkpoint"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="4" ValueType="60">
<xsl:value-of select="sql:klassification"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="5" ValueType="60">
<xsl:value-of select="sql:checklocation"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="6" ValueType="60">
<xsl:value-of select="sql:guard_1"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="7" ValueType="60">
<xsl:value-of select="sql:guard_2"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="8" ValueType="60">
<xsl:value-of select="sql:objection"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="9" ValueType="60">
<xsl:value-of select="sql:dtg"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="10" ValueType="60">
<xsl:value-of select="sql:location"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="11" ValueType="60">
<xsl:value-of select="sql:description"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="12" ValueType="60">
<xsl:value-of select="sql:numberofpersons"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="13" ValueType="60">
<xsl:value-of select="sql:observed"/>
</gmr:Cell>
</xsl:template>
</xsl:stylesheet>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: transformation from XML to excel only works with one element
set
Posted by Antonio Gallardo <ag...@agssa.net>.
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: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org