|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] 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>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|

Cart








