如下文件是由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>
<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>
Excel格式是不固定的,都是动态生出来的