Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing XML with XSL into Excel fails
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-com:office:spreadsheet" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" <xsl:template match="xsl:stylesheet"/ <xsl:template match="NewDataSet" <Workbook 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" <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 <ContentKeyDatabase</ContentKey <LocalizedContentDatabase**</LocalizedContent </Login <Login <ContentKeyHeaderText</ContentKey <LocalizedContentCMT Login12</LocalizedContent </Login </NewDataSet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula fails to update | Excel Discussion (Misc queries) | |||
Excel fails to save | Excel Discussion (Misc queries) | |||
excel fails to launch | Excel Discussion (Misc queries) | |||
Excel Template fails to open??? | Excel Discussion (Misc queries) | |||
Excel Fails when add-in is selected | Excel Worksheet Functions |