JS 最简单的XML格式Excel表格文件

• JS 将数据生成Excel(XML) 并保存为.xls文件，已封装可以直接使用

• 简单写法：

  <?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">
    <Worksheet ss:Name="tt">
      <Table>
        <Row>
          <Cell><Data ss:Type="String">Hello!World!</Data></Cell>
          <Cell><Data ss:Type="Number">123</Data></Cell>
        </Row>
      </Table>
    </Worksheet>
  </Workbook>
  

• 注意 ss:Type=“String” 里面的类型需要首字母大写。

---

---

• 复杂写法，需要包含字体，字号，颜色…

  <?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">
      <Title>Excel表格</Title>
      <LastAuthor>bigtall</LastAuthor>
    </DocumentProperties>
    <Styles>
      <Style ss:ID="Default" ss:Name="Normal">
        <Alignment ss:Vertical="Center"/>
        <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/>
      </Style>
    </Styles>
    <Worksheet ss:Name="tt">
      <Table>
        <Row>
          <Cell ss:MergeAcross="6" ><Data ss:Type="String">Hello!World!</Data></Cell>
        </Row>
      </Table>
    </Worksheet>
  </Workbook>