SQL代码
- <?xml version="1.0" encoding="UTF-8"?>
- <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
- 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="Table1">
- <Table>
- <Column ss:Index="1" ss:AutoFitWidth="0" ss:Width="110"/>
- <Row>
- <Cell><Data ss:Type="String">一行</Data></Cell>
- </Row>
- <Row>
- <Cell><Data ss:Type="String">二行</Data></Cell>
- </Row>
- <Row>
- <Cell><Data ss:Type="String">1列</Data></Cell>
- <Cell><Data ss:Type="String">2列</Data></Cell>
- <Cell><Data ss:Type="String">3列</Data></Cell>
- <Cell><Data ss:Type="String">4列</Data></Cell>
- <Cell><Data ss:Type="String">5列</Data></Cell>
- <Cell><Data ss:Type="String">6列</Data></Cell>
- <Cell><Data ss:Type="String">7列</Data></Cell>
- </Row>
- </Table>
- </Worksheet>
- </Workbook>
由此,可以自己写个Export To Excel咯