[xsl] problem with spreadsheet-like xml structure

Subject: [xsl] problem with spreadsheet-like xml structure
From: max@xxxxxxxxxx
Date: Sat, 11 Jun 2005 22:39:39 +0200 (CEST)
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