Solved

Create XML Spreadsheet ???

Posted on 2004-09-21
10
2,000 Views
Last Modified: 2013-11-19
hello everybody
i have one file XML, import to excel(Excel 2003) without xsl style file ->>OK
but with my xsl file error : Import XML Error

error code: -1072896682
URL : ..\temp\6b1.tmp
Reason: Invalid at the top level of the document.
Line : 1
Column: 22
File Offset :21


Excel 2003
Souce XSL file:
------
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD">

<xsl:template match="/">
<xsl:pi name="xml">version="1.0"</xsl:pi>
<?mso-application progid="Excel.Sheet"?>
<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"
 xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <LastAuthor>BTC</LastAuthor>
  <Created>2004-09-22T04:26:42Z</Created>
  <Version>11.6360</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>9345</WindowHeight>
  <WindowWidth>15135</WindowWidth>
  <WindowTopX>120</WindowTopX>
  <WindowTopY>45</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
  <FutureVer>11</FutureVer>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="VNI-Times"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s22">
   <NumberFormat/>
  </Style>
  <Style ss:ID="s23">
   <NumberFormat ss:Format="@"/>
  </Style>
  <Style ss:ID="s24">
   <Font ss:FontName="VNI-Times" ss:Bold="1"/>
   <Interior ss:Color="#00CCFF" ss:Pattern="Solid"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Sheet1">
  <Names>
   <NamedRange ss:Name="_FilterDatabase" ss:RefersTo="=Sheet1!R4C3:R6C12"
    ss:Hidden="1"/>
  </Names>
  <Table ss:ExpandedColumnCount="12" ss:ExpandedRowCount="6" x:FullColumns="1"
   x:FullRows="1" ss:DefaultRowHeight="14.25">
   <Column ss:Width="27.75"/>
   <Column ss:Width="77.25"/>
   <Column ss:Width="55.5"/>
   <Column ss:Width="96.75"/>
   <Column ss:Width="46.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="86.25"/>
   <Column ss:Width="36.75"/>
   <Column ss:Width="47.25"/>
   <Column ss:Width="52.5"/>
   <Column ss:Width="72.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="64.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="65.25"/>
   <Row ss:Index="4" ss:Height="15.75">
    <Cell ss:Index="3" ss:StyleID="s24"><Data ss:Type="String">ID</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">TenHC</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">MaHC</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">NCC</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">DVT</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">SL</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">DG</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">TT</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">VAT</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">TONGCONG</Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
   </Row>
<xsl:for-each select="xml/rs:data/z:row">
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s23"><Data ss:Type="Number"><xsl:value-of select="@ID"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String"><xsl:value-of select="@TenHC"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String"><xsl:value-of select="@MaHC"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String"><xsl:value-of select="@NCC"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String"><xsl:value-of select="@DVT"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number"><xsl:value-of select="@SL"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number"><xsl:value-of select="@DG"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number"><xsl:value-of select="@TT"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number"><xsl:value-of select="@VAT"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number"><xsl:value-of select="@TONGCONG"/></Data><NamedCell
      ss:Name="_FilterDatabase"/></Cell>
   </Row>
</xsl:for-each>
   <Row>
    <Cell ss:Index="3" ss:StyleID="s22"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s23"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s22"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s22"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s22"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s22"><NamedCell ss:Name="_FilterDatabase"/></Cell>
    <Cell ss:StyleID="s22"><NamedCell ss:Name="_FilterDatabase"/></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>5</ActiveRow>
     <ActiveCol>7</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
 <Worksheet ss:Name="Sheet2">
  <Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"
   x:FullRows="1" ss:DefaultRowHeight="14.25"/>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
 <Worksheet ss:Name="Sheet3">
  <Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"
   x:FullRows="1" ss:DefaultRowHeight="14.25"/>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
 <x2:MapInfo x2:HideInactiveListBorder="false">
  <x2:Schema x2:ID="Schema1" x2:Namespace=""><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"><xsd:element nillable="true" name="NewDataSet"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="TblTONKHO" form="unqualified"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="ID" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string" name="TenHC" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string" name="MaHC" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string" name="NCC" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:string" name="DVT" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="SL" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="DG" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="TT" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:double" name="VAT" form="unqualified"></xsd:element><xsd:element minOccurs="0" nillable="true" type="xsd:double" name="TONGCONG" form="unqualified"></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:schema></x2:Schema>
  <x2:Map x2:ID="NewDataSet_Map" x2:SchemaID="Schema1" x2:RootElement="NewDataSet">
   <x2:Entry x2:Type="table" x2:ID="5" x2:ShowTotals="false">
    <x2:Range>Sheet1!R5C3:R6C12</x2:Range>
    <x2:HeaderRange>R4C3</x2:HeaderRange>
    <x:FilterOn>False</x:FilterOn>
    <x2:XPath>/NewDataSet/TblTONKHO</x2:XPath>
    <x2:Field x2:ID="ID">
     <x2:Range>RC</x2:Range>
     <x2:XPath>ID</x2:XPath>
     <x2:XSDType>integer</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="TenHC">
     <x2:Range>RC[1]</x2:Range>
     <x2:XPath>TenHC</x2:XPath>
     <x2:XSDType>string</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="MaHC">
     <x2:Range>RC[2]</x2:Range>
     <x2:XPath>MaHC</x2:XPath>
     <x2:XSDType>string</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="NCC">
     <x2:Range>RC[3]</x2:Range>
     <x2:XPath>NCC</x2:XPath>
     <x2:XSDType>string</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="DVT">
     <x2:Range>RC[4]</x2:Range>
     <x2:XPath>DVT</x2:XPath>
     <x2:XSDType>string</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="SL">
     <x2:Range>RC[5]</x2:Range>
     <x2:XPath>SL</x2:XPath>
     <x2:XSDType>integer</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="DG">
     <x2:Range>RC[6]</x2:Range>
     <x2:XPath>DG</x2:XPath>
     <x2:XSDType>integer</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="TT">
     <x2:Range>RC[7]</x2:Range>
     <x2:XPath>TT</x2:XPath>
     <x2:XSDType>integer</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="VAT">
     <x2:Range>RC[8]</x2:Range>
     <x2:XPath>VAT</x2:XPath>
     <x2:XSDType>double</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
    <x2:Field x2:ID="TONGCONG">
     <x2:Range>RC[9]</x2:Range>
     <x2:XPath>TONGCONG</x2:XPath>
     <x2:XSDType>double</x2:XSDType>
     <ss:Cell>
     </ss:Cell>
     <x2:Aggregate>None</x2:Aggregate>
    </x2:Field>
   </x2:Entry>
  </x2:Map>
 </x2:MapInfo>
 <x2:Binding x2:ID="Binding1" x2:LoadMode="normal">
  <x2:MapID>NewDataSet_Map</x2:MapID>
<udc:DataSource MajorVersion="1" MinorVersion="0" xmlns:udc="http://schemas.microsoft.com/data/udc">
  <udc:Type Type="XMLFile" MajorVersion="1" MinorVersion="0"/>
  <udc:Name>Binding1</udc:Name>
  <udc:ConnectionInfo Purpose="Query">
    <udcxf:File xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile">C:\Customers.xml</udcxf:File>
  </udc:ConnectionInfo>
</udc:DataSource>
 </x2:Binding>
</Workbook>
</xsl:template>
</xsl:stylesheet>
</xsl:stylesheet>


-------------------------
Please help me
0
Comment
Question by:LearnITvn
  • 3
  • 3
  • 2
10 Comments
 
LVL 7

Expert Comment

by:J_Mak
ID: 12120300
One big problem you have is that you have two <xsl:stylesheet> elements. There should only be one. That is, instead of having:

<xsl:stylesheet>
   <xsl:stylesheet>
   ......
   </xsl:stylesheet>
</xsl:stylesheet>

just leave it like this:

<xsl:stylesheet>
   ......
</xsl:stylesheet>

Also, why are you importing a stylesheet? You only ever import XML files into Excel. Stylesheets are rules which define an XML transformation, they can't be visually represented.
0
 

Author Comment

by:LearnITvn
ID: 12120740
Hi J_Mak
when only one <xsl:stylesheet>, it's don't work, too
above code from : http://support.microsoft.com/default.aspx?scid=kb;EN-US;285891
please port sample code "XSL Style, Open XML with XSL style in Excel " if you have
Thanks
0
 
LVL 15

Expert Comment

by:dualsoul
ID: 12120959
hm...i'm not sure i understand the task you are trying to solve.

but as  J_Mak  said, you have 2 same namespaces with different urls - how you want to distinguish them?
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 7

Expert Comment

by:J_Mak
ID: 12129524
instead of using xmlns:xsl="http://www.w3.org/TR/WD"

try xmlns:xsl="http://www.w3.org/TR/WD-xsl"

But i still don't see the point of importing a stylesheet into Excel.

Cheers.
0
 

Author Comment

by:LearnITvn
ID: 12129910
HI J_Mak  
if try xmlns:xsl="http://www.w3.org/TR/WD-xsl" then
error: The "http://www.w3.org/TR/WD-xsl"  namespace is no longer supported in this version of MSXML

what happen??
0
 
LVL 15

Expert Comment

by:dualsoul
ID: 12131009
LearnITvn , are you able to explain what are you trying to do?
0
 

Author Comment

by:LearnITvn
ID: 12139169
hi dualsoul
I have a XML file, I want open it in excel with XSL style
0
 
LVL 7

Accepted Solution

by:
J_Mak earned 500 total points
ID: 12140025
You cannot do that. Excel only has the ability to open Excel XMLfiles which have been formatted in properly in XML.

Have a look at this link for more information:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlsmlinss.asp

What you need to do is create a stylesheet which you can use to transform something into ExcelXML format so that you can see it in Excel.

Cheers.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question