Subject: RE: [xsl] problem with spreadsheet-like xml structure From: "Michael Kay" <mike@xxxxxxxxxxxx> Date: Sat, 11 Jun 2005 21:46:20 +0100 |
If you know that the data is in groups of three, you can use <xsl:template match="row"> <xsl:for-each select="cell[position() mod 3 = 1]"> <location> <name><xsl:value-of select="."/></name> <note><xsl:value-of select="following-sibling::cell[1]"/></note> <date><xsl:value-of select="following-sibling::cell[2]"/></date> </location> </ </ Michael Kay http://www.saxonica.com/ > -----Original Message----- > From: max@xxxxxxxxxx [mailto:max@xxxxxxxxxx] > Sent: 11 June 2005 21:40 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: [xsl] problem with spreadsheet-like xml structure > > Hi all, > > I am trying to convert data in an Excel's xml-format to a > custom xml-format. > The logical structure of the Excel data is > > <table> > <row> > > <cell> location1 <cell> > <cell> note <cell> > <cell> date1 <cell> > > <cell> location2 <cell> > <cell> note2 <cell> > <cell> date2 <cell> > > <cell> location3 <cell> > <cell> note3 <cell> > <cell> date3 <cell> > > </row> > <row> > ... > </row> > </table> > > What I need is: > > <row> > > <location date="date1"> > <name>location1</name> > <note>note1</note> > </location> > > <location date="date2"> > <name>location2</name> > <note>note2</note> > </location> > > <location date="date3"> > <name>location3</name> > <note>note3</note> > </location> > > <row> > > I can get the location cells ( using position() ) and place > the cell data > into my location element but > then I don't know how to place the following cells inside > this location > element. > > <xsl:if test="position() =1 "> > <xsl:element name="location"> > <xsl:element name="name"> > <xsl:value-of select="."/> > </xsl:element> > > <!-- PLACE HERE NEXT TWO CELLS --> > > </xsl:element> > </xsl:if>
Current Thread |
---|
<- Previous | Index | Next -> |
---|---|---|
[xsl] problem with spreadsheet-like, max | Thread | RE: [xsl] problem with spreadsheet-, max |
[xsl] problem with spreadsheet-like, max | Date | RE: [xsl] problem with spreadsheet-, max |
Month |