完整的XML都有啥,做Excel的朋友注意了
<?xml version="1.0" encoding="utf-8"?>
<?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">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> </DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<RemovePersonalInformation/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> </ExcelWorkbook>
<Styles>
<Style ss:ID="col_Field3">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="col_Field8">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="col_Field1">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="col_Field2">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="col_Field4">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="col_Field5">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="col_Field6">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="col_Field7">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="MTitleDataStyle">
<Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="16" ss:Color="#000000" ss:Bold="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="STitleDataStyle">
<Alignment ss:Horizontal="Right" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="14" ss:Color="#000000" ss:Bold="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="TableDataStyle">
<Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Color="#000000"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="TableHeadStyle">
<Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Color="#000000" ss:Bold="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Interior ss:Color="#D8D8D8" ss:Pattern="Solid"/>
</Style>
</Styles>
<Worksheet ss:Name="sheet名字">
<Table ss:ExpandedColumnCount="9" ss:ExpandedRowCount="16" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="100" ss:DefaultRowHeight="16">
<Column ss:Index="1" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:Index="3" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:Index="4" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:Index="6" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:Index="7" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:Index="8" ss:AutoFitWidth="0" ss:Width="100"/>
<Row ss:Index="2" ss:AutoFitHeight="0" ss:Height="40">
<Cell ss:Index="2" ss:MergeAcross="7" ss:StyleID="MTitleDataStyle">
<Data ss:Type="String">主标题</Data>
</Cell>
</Row>
<Row ss:Index="3" ss:AutoFitHeight="0" ss:Height="26">
<Cell ss:Index="2" ss:MergeAcross="7" ss:StyleID="STitleDataStyle">
<Data ss:Type="String">父标题</Data>
</Cell>
</Row>
<Row ss:Index="4" ss:AutoFitHeight="0">
<Cell ss:StyleID="TableHeadStyle" ss:Index="2" ss:MergeDown="1" ss:MergeAcross="1">
<Data ss:Type="String">合并行列</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="4" ss:MergeDown="2" ss:MergeAcross="0">
<Data ss:Type="String">字段3</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="5" ss:MergeDown="0" ss:MergeAcross="3">
<Data ss:Type="String">合并行1</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="9" ss:MergeDown="2" ss:MergeAcross="0">
<Data ss:Type="String">字段8</Data>
</Cell>
</Row>
<Row ss:Index="5" ss:AutoFitHeight="0">
<Cell ss:StyleID="TableHeadStyle" ss:Index="5" ss:MergeDown="0" ss:MergeAcross="1">
<Data ss:Type="String">合并行2</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="7" ss:MergeDown="0" ss:MergeAcross="1">
<Data ss:Type="String">合并行3</Data>
</Cell>
</Row>
<Row ss:Index="6" ss:AutoFitHeight="0">
<Cell ss:StyleID="TableHeadStyle" ss:Index="2" ss:MergeDown="0" ss:MergeAcross="0">
<Data ss:Type="String">字段1</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="3" ss:MergeDown="0" ss:MergeAcross="0">
<Data ss:Type="String">字段2</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="5" ss:MergeDown="0" ss:MergeAcross="0">
<Data ss:Type="String">字段4</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="6" ss:MergeDown="0" ss:MergeAcross="0">
<Data ss:Type="String">字段5</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="7" ss:MergeDown="0" ss:MergeAcross="0">
<Data ss:Type="String">字段6</Data>
</Cell>
<Cell ss:StyleID="TableHeadStyle" ss:Index="8" ss:MergeDown="0" ss:MergeAcross="0">
<Data ss:Type="String">字段7</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell field="Field3" ss:StyleID="col_Field3" ss:Index="2">
<Data ss:Type="String">数据31</Data>
</Cell>
<Cell field="Field8" ss:StyleID="col_Field8" ss:Index="3">
<Data ss:Type="String">数据81</Data>
</Cell>
<Cell field="Field1" ss:StyleID="col_Field1" ss:Index="4">
<Data ss:Type="String">数据11</Data>
</Cell>
<Cell field="Field2" ss:StyleID="col_Field2" ss:Index="5">
<Data ss:Type="String">数据21</Data>
</Cell>
<Cell field="Field4" ss:StyleID="col_Field4" ss:Index="6">
<Data ss:Type="String">数据41</Data>
</Cell>
<Cell field="Field5" ss:StyleID="col_Field5" ss:Index="7">
<Data ss:Type="String">数据51</Data>
</Cell>
<Cell field="Field6" ss:StyleID="col_Field6" ss:Index="8">
<Data ss:Type="String">数据61</Data>
</Cell>
<Cell field="Field7" ss:StyleID="col_Field7" ss:Index="9">
<Data ss:Type="String">数据71</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell field="Field3" ss:StyleID="col_Field3" ss:Index="2">
<Data ss:Type="String">数据32</Data>
</Cell>
<Cell field="Field8" ss:StyleID="col_Field8" ss:Index="3">
<Data ss:Type="String">数据82</Data>
</Cell>
<Cell field="Field1" ss:StyleID="col_Field1" ss:Index="4">
<Data ss:Type="String">数据12</Data>
</Cell>
<Cell field="Field2" ss:StyleID="col_Field2" ss:Index="5">
<Data ss:Type="String">数据22</Data>
</Cell>
<Cell field="Field4" ss:StyleID="col_Field4" ss:Index="6">
<Data ss:Type="String">数据42</Data>
</Cell>
<Cell field="Field5" ss:StyleID="col_Field5" ss:Index="7">
<Data ss:Type="String">数据52</Data>
</Cell>
<Cell field="Field6" ss:StyleID="col_Field6" ss:Index="8">
<Data ss:Type="String">数据62</Data>
</Cell>
<Cell field="Field7" ss:StyleID="col_Field7" ss:Index="9">
<Data ss:Type="String">数据72</Data>
</Cell>
</Row>
</Table>
</Worksheet>
</Workbook>
需要注意的是里面的 Index及ss:MergeDown及ss:MergeAcross