inabethtic
New Member
I'm getting data from an XML-file and transforming it with XSLT. I have one node that I want to create a table from. \[code\]<?xml version="1.0" encoding="utf-8"?><xsl:stylesheet version="1.0"xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:variable name="file" select="document('file.xml')"/><xsl:template match="/"><html xmlns="http://www.w3.org/1999/xhtml"> <head> <title></title> </head> <body> <table> <xsl:value-of select="$file/Workbook/Worksheet/Table"/> </table> </body></html>\[/code\]\[code\]//output: id firstname lastname 8 Jonas Berg 15 Adam Jones ...\[/code\]I want the table to look like:\[code\]id firstname lastname8 Jonas Berg ...\[/code\]Can I do that?XML sample from table:\[code\] <Row><Cell ss:Index="2"><Data ss:Type="String">id</Data></Cell><Cell ss:StyleID="s62"><Data ss:Type="String">firstname</Data></Cell><Cell><Data ss:Type="String">lastname</Data></Cell> </Row> <Row> <Cell ss:Index="2"><Data ss:Type="Number">8</Data></Cell> <Cell ss:StyleID="s62"><Data ss:Type="String">Jonas</Data></Cell> <Cell><Data ss:Type="String">Berg</Data></Cell> </Row>\[/code\]