导出excel报表的另类方法 输出到多个excel sheet 中

 

<?xml version="1.0"?>
<?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="Sheet1">
  <Table >
   <Row>
    <Cell><Data ss:Type="String">sheet1tab</Data></Cell>
    <Cell><Data ss:Type="String">sheet1tab</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">sheet1tab</Data></Cell>
    <Cell><Data ss:Type="String">sheet1tab</Data></Cell>
   </Row>
  </Table>
 </Worksheet>
 <Worksheet ss:Name="Sheet2">
  <Table >
   <Row>
    <Cell><Data ss:Type="String">sheet2tabfff</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="String">sheet1tab</Data></Cell>
    <Cell><Data ss:Type="String">sheet1tab</Data></Cell>
   </Row>
  </Table>
 </Worksheet>
</Workbook>