輸出 Excel檔案，有多個Work Sheet（工作表）？

Excel 2003當我們另存新檔，會有一個「Excel XML」檔的選項。
存檔後，XML格式如下：

---

<?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 ss:ExpandedColumnCount="2" ss:ExpandedRowCount="3" x:FullColumns="1"

x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="16.5">

<Row>

<Cell><Data ss:Type="Number">1</Data></Cell>

<Cell><Data ss:Type="String">aaa</Data></Cell>

</Row>

<Row>

<Cell><Data ss:Type="Number">2</Data></Cell>

<Cell><Data ss:Type="String">bbb</Data></Cell>

</Row>

<Row>

<Cell><Data ss:Type="Number">3</Data></Cell>

<Cell><Data ss:Type="String">ccc</Data></Cell>

</Row>

</Table>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

<Worksheet ss:Name="Sheet2">

<Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"

x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="16.5"/>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

<Worksheet ss:Name="Sheet3">

<Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"

x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="16.5"/>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

</Workbook>

　

到我網站去看看 http://www.taconet.com.tw/mis2000_aspnet/ASP_NET20.htm#22_excel

---

看看上面的XML碼，您就知道不同的 Work Sheet該怎麼作了。
把資料庫裡面的資料，透過XML排版，就能把結果輸出成 Excel檔案。

而且有多個 Work Sheet