M
Madhukar
Hi,
I am trying to open following XML file ab.xml into Excel 2003/2007 which
gives following error
Required attribute '{http://www.w3.org/1999/XSL/Transform}version' is missing.
Am I missing anything? please help.
Following are the contents of ab.xml file which contains XSL to Transform
data into worksheets.
<?xml version="1.0"?>
<?xml-stylesheet version="1.0" href="#exportstyle" type="text/xsl"?>
<!DOCTYPE NewDataSet [
<!ATTLIST xsl:stylesheet
id ID #REQUIRED>
]>
<NewDataSet>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
id="exportstyle"
xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet" >
<xsl:template match="xsl:stylesheet"/>
<xsl:template match="NewDataSet">
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet>
<xsl:attribute name="ss:Name">Login</xsl:attribute>
<Table>
<xsl:apply-templates select="NewDataSet"/>
<Row>
<Cell>
<Data ss:Type="String">ContentKey</Data>
</Cell>
<Cell>
<Data ss:Type="String">LocalizedContent</Data>
</Cell>
</Row>
<xsl:for-each select="Login">
<Row>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="ContentKey"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="LocalizedContent"/>
</Data>
</Cell>
</Row>
</xsl:for-each>
</Table>
</Worksheet>
</Workbook>
</xsl:template>
</xsl:stylesheet>
<Login>
<ContentKey>Database</ContentKey>
<LocalizedContent>Database**</LocalizedContent>
</Login>
<Login>
<ContentKey>HeaderText</ContentKey>
<LocalizedContent>CMT Login12</LocalizedContent>
</Login>
</NewDataSet>
I am trying to open following XML file ab.xml into Excel 2003/2007 which
gives following error
Required attribute '{http://www.w3.org/1999/XSL/Transform}version' is missing.
Am I missing anything? please help.
Following are the contents of ab.xml file which contains XSL to Transform
data into worksheets.
<?xml version="1.0"?>
<?xml-stylesheet version="1.0" href="#exportstyle" type="text/xsl"?>
<!DOCTYPE NewDataSet [
<!ATTLIST xsl:stylesheet
id ID #REQUIRED>
]>
<NewDataSet>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
id="exportstyle"
xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet" >
<xsl:template match="xsl:stylesheet"/>
<xsl:template match="NewDataSet">
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet>
<xsl:attribute name="ss:Name">Login</xsl:attribute>
<Table>
<xsl:apply-templates select="NewDataSet"/>
<Row>
<Cell>
<Data ss:Type="String">ContentKey</Data>
</Cell>
<Cell>
<Data ss:Type="String">LocalizedContent</Data>
</Cell>
</Row>
<xsl:for-each select="Login">
<Row>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="ContentKey"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="LocalizedContent"/>
</Data>
</Cell>
</Row>
</xsl:for-each>
</Table>
</Worksheet>
</Workbook>
</xsl:template>
</xsl:stylesheet>
<Login>
<ContentKey>Database</ContentKey>
<LocalizedContent>Database**</LocalizedContent>
</Login>
<Login>
<ContentKey>HeaderText</ContentKey>
<LocalizedContent>CMT Login12</LocalizedContent>
</Login>
</NewDataSet>