XMLSS to XML

[Swapnil Shroff]

I want to design an XSLT that will process each ROW in XMLSS format and generate an XML file.

I am doing following to process each row

 <?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" 
    xmlns="urn:schemas-microsoft-com:office:spreadsheet"   xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
    xmlns:html="http://www.w3.org/TR/REC-html40" >
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
    <xsl:element name="testscenarios">
        <xsl:value-of select="/Workbook/Worksheet[@ss:Name='Sheet1']/Table/Row[position()>3]/Cell/Data[@ss:Type='Number']"/>
        <xsl:apply-templates select="/Workbook/Worksheet[@ss:Name='Sheet1']/Table/Row[position()>3]" />
    </xsl:element>
</xsl:template>
 <xsl:template match="Row">
<!-- PROCESS ELEMENT -->
 </xsl:template>
</xsl:stylesheet>
   

However it doesn't work. Please advice.

Thanks in advance

(Edited so it isn't twice as wide as my screen - PC)
[ March 28, 2008: Message edited by: Paul Clapham ]

[Paul Clapham]

Your first step should be to identify in what way it "doesn't work". Then you will have something solid to work on. Right now you have no idea what the problem is. (Or if you do, you didn't mention it here.)

Look for error messages and stack traces. Or if the transformation runs to completion, try to identify what it does, what you wanted it to do, and what the difference between those two things is.