-- 作者:czl923
-- 发布时间:8/19/2011 3:15:00 PM
-- [求助]特殊xml to excel 寻求帮助...
如下文件是由owc控件自动生成的,想转成excel文件 纠结了很长时间,求思路!!! <?xml version="1.0"?> <ss:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"> <x:ExcelWorkbook> <x:ProtectStructure>False</x:ProtectStructure> <x:ActiveSheet>0</x:ActiveSheet> </x:ExcelWorkbook> <ss:Styles> <ss:Style ss:ID="Default"> <ss:Alignment ss:Horizontal="Automatic" ss:Rotate="0.0" ss:Vertical="Bottom" ss:ReadingOrder="Context"/> <ss:Borders> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="11" ss:Color="Automatic" ss:Bold="0" ss:Italic="0" ss:Underline="None"/> <ss:Interior ss:Color="Automatic" ss:Pattern="None"/> <ss:NumberFormat ss:Format="General"/> <ss:Protection ss:Protected="1"/> </ss:Style> <ss:Style ss:ID="wc0DDCDC0000000000"> <ss:Alignment ss:Vertical="Center"/> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="wc0DDC060000000000"> <ss:Alignment ss:Horizontal="Center" ss:Vertical="Center"/> <ss:Borders> <ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1.0"/> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="wc0DDC070000000000"> <ss:Alignment ss:Horizontal="Center" ss:Vertical="Center"/> <ss:Borders> <ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1.0"/> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="wc0DDC080000000000"> <ss:Alignment ss:Horizontal="Center" ss:Vertical="Center"/> <ss:Borders> <ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1.0"/> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="wc0DDC090000000000"> <ss:Alignment ss:Vertical="Center"/> <ss:Borders> <ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1.0"/> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="wc0DDC0A0000000000"> <ss:Alignment ss:Vertical="Center"/> <ss:Borders> <ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1.0"/> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="wc0DDC0B0000000000"> <ss:Alignment ss:Vertical="Center"/> <ss:Borders> <ss:Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1.0"/> <ss:Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1.0"/> </ss:Borders> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="wc0D8C9B0000000000"> <ss:Alignment ss:Horizontal="Center" ss:Vertical="Top"/> <ss:Font ss:FontName="宋体" ss:Size="11"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="mc0DDCD9000DDCDB00"> <ss:Alignment ss:Horizontal="Right" ss:Vertical="Center"/> <ss:Font ss:FontName="宋体" ss:Size="9"/> <ss:Interior/> </ss:Style> <ss:Style ss:ID="mc0DDC48000DDCD800"> <ss:Alignment ss:Horizontal="Center" ss:Vertical="Center"/> <ss:Font ss:FontName="宋体" ss:Size="18"/> <ss:Interior/> </ss:Style> </ss:Styles> <c:ComponentOptions> <c:Label> <c:Caption>Microsoft Office Spreadsheet</c:Caption> </c:Label> <c:MaxHeight>80%</c:MaxHeight> <c:MaxWidth>80%</c:MaxWidth> <c:NextSheetNumber>2</c:NextSheetNumber> </c:ComponentOptions> <x:WorkbookOptions> <c:OWCVersion>12.0.0.4518 </c:OWCVersion> </x:WorkbookOptions> <ss:Worksheet ss:Name="D002"> <x:WorksheetOptions> <x:Selected/> <x:DoNotDisplayGridlines/> <x:ViewableRange>R1:R65536</x:ViewableRange> <x:Selection>R1C1:R1C3</x:Selection> <x:TopRowVisible>0</x:TopRowVisible> <x:LeftColumnVisible>0</x:LeftColumnVisible> <x:ProtectContents>False</x:ProtectContents> </x:WorksheetOptions> <c:WorksheetOptions> </c:WorksheetOptions> <ss:Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="8" ss:DefaultColumnWidth="54.0" ss:DefaultRowHeight="12.75"> <ss:Column ss:Width="53.25"/> <ss:Column ss:Span="1" ss:Width="66.75"/> <ss:Row ss:Height="35.25" ss:AutoFitHeight="0"> <ss:Cell ss:MergeAcross="2" ss:StyleID="mc0DDC48000DDCD800"> <ss:Data ss:Type="String">计算机行业调查表</ss:Data> </ss:Cell> </ss:Row> <ss:Row ss:Height="15.75" ss:AutoFitHeight="0"> <ss:Cell ss:MergeAcross="2" ss:StyleID="mc0DDCD9000DDCDB00"> <ss:Data ss:Type="String">表 号:D002</ss:Data> </ss:Cell> </ss:Row> <ss:Row ss:Height="15.75" ss:AutoFitHeight="0"> <ss:Cell ss:MergeAcross="2" ss:StyleID="mc0DDCD9000DDCDB00"> <ss:Data ss:Type="String">制表机关:国 家 统 计 局</ss:Data> </ss:Cell> </ss:Row> <ss:Row ss:Height="15.75" ss:AutoFitHeight="0"> <ss:Cell ss:MergeAcross="2" ss:StyleID="mc0DDCD9000DDCDB00"> <ss:Data ss:Type="String">文号:国统字</ss:Data> </ss:Cell> </ss:Row> <ss:Row ss:Height="15.75" ss:AutoFitHeight="0"> <ss:Cell ss:StyleID="wc0DDCDC0000000000"> <ss:Data ss:Type="String">单位名称:</ss:Data> </ss:Cell> <ss:Cell ss:StyleID="wc0DDCDC0000000000"/> <ss:Cell ss:StyleID="wc0DDCDC0000000000"> <ss:Data ss:Type="String">计量单位:</ss:Data> </ss:Cell> </ss:Row> <ss:Row ss:Height="15.75" ss:AutoFitHeight="0" ss:StyleID="wc0D8C9B0000000000"> <ss:Cell ss:StyleID="wc0DDC060000000000"> <ss:Data ss:Type="String">序号</ss:Data> </ss:Cell> <ss:Cell ss:StyleID="wc0DDC070000000000"> <ss:Data ss:Type="String">本年本月止累计</ss:Data> </ss:Cell> <ss:Cell ss:StyleID="wc0DDC080000000000"> <ss:Data ss:Type="String">去年同月止累计</ss:Data> </ss:Cell> </ss:Row> <ss:Row ss:Height="15.75" ss:AutoFitHeight="0"> <ss:Cell ss:StyleID="wc0DDC090000000000"> <ss:Data ss:Type="String"> </ss:Data> </ss:Cell> <ss:Cell ss:StyleID="wc0DDC0A0000000000"> <ss:Data ss:Type="String"> </ss:Data> </ss:Cell> <ss:Cell ss:StyleID="wc0DDC0B0000000000"> <ss:Data ss:Type="String"> </ss:Data> </ss:Cell> </ss:Row> <ss:Row ss:Height="15.75" ss:AutoFitHeight="0"> <ss:Cell ss:StyleID="wc0DDCDC0000000000"> <ss:Data ss:Type="String">单位负责人:</ss:Data> </ss:Cell> <ss:Cell ss:StyleID="wc0DDCDC0000000000"> <ss:Data ss:Type="String">填报日期:</ss:Data> </ss:Cell> <ss:Cell ss:StyleID="wc0DDCDC0000000000"> <ss:Data ss:Type="String">填表人:</ss:Data> </ss:Cell> </ss:Row> </ss:Table> </ss:Worksheet> </ss:Workbook>
|