以文本方式查看主题

-  中文XML论坛 - 专业的XML技术讨论区  (http://bbs.xml.org.cn/index.asp)
--  『 WORD to XML, HTML to XML 』  (http://bbs.xml.org.cn/list.asp?boardid=13)
----  [求助]特殊xml to excel 寻求帮助...  (http://bbs.xml.org.cn/dispbbs.asp?boardid=13&rootid=&id=95226)


--  作者: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>


W 3 C h i n a ( since 2003 ) 旗 下 站 点
苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
7,855.469ms