程式匯出Excel 時可用以下格式
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
| <?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">aaaaaa</Data></Cell>
<Cell><Data ss:Type="String">aaaaa2</Data></Cell>
<Cell><Data ss:Type="String">aaaa33</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">1515aaa</Data></Cell>
<Cell><Data ss:Type="String">56516aaaa2</Data></Cell>
<Cell><Data ss:Type="String">a546456aaa33</Data></Cell>
</Row>
</Table>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<Table>
<Row ss:Index="5">
<Cell><Data ss:Type="String">bbbbbb</Data></Cell>
</Row>
</Table>
</Worksheet>
<Worksheet ss:Name="Sheet3">
<Table>
<Row>
<Cell ss:Index="4"><Data ss:Type="String">ccccccc</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>
|
以上格式可將檔案匯出成xml 檔或是xls檔, 是多Sheet 的方法!!
可用於php asp.net asp vb c# …..等各種程式 !!