最简单的XML格式Excel表格文件
最简单的XML格式Excel表格文件
当然，还有几个地方是可以删除掉的内容，但是这样就有些破坏完整性了。这个文档的作用就是从XML数据源中导出数据之后，使用XSLT转换也可以把数据导出。简单！
<?
xmlversion="1.0"
?>
mso-applicationprogid="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
xmlns:html ="http://www.w3.org/TR/REC-html40" >
DocumentProperties ="urn:schemas-microsoft-com:office:office" Title >Excel表格 </ LastAuthor >bigtall DocumentProperties Styles Style ss:ID ="Default" ss:Name ="Normal" Alignment ss:Vertical ="Center" />
Font ss:FontName ="宋体" x:CharSet ="134" ss:Size ="12" Style Worksheet ="tt" Table Row Cell ss:MergeAcross ="6" >< Data ss:Type ="String" >Hello!World! Data ></ Cell Worksheet Workbook >
mso-applicationprogid="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
xmlns:html ="http://www.w3.org/TR/REC-html40" >
DocumentProperties ="urn:schemas-microsoft-com:office:office" Title >Excel表格 </ LastAuthor >bigtall DocumentProperties Styles Style ss:ID ="Default" ss:Name ="Normal" Alignment ss:Vertical ="Center" />
Font ss:FontName ="宋体" x:CharSet ="134" ss:Size ="12" Style Worksheet ="tt" Table Row Cell ss:MergeAcross ="6" >< Data ss:Type ="String" >Hello!World! Data ></ Cell Worksheet Workbook >
其实还可以精简到这样：
<?
xmlversion="1.0"
?>
mso-applicationprogid="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
xmlns:html ="http://www.w3.org/TR/REC-html40" >
Worksheet ss:Name ="tt" Table Row Cell >< Data ss:Type ="String" >Hello!World! </ Data ></ Worksheet Workbook >
mso-applicationprogid="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
xmlns:html ="http://www.w3.org/TR/REC-html40" >
Worksheet ss:Name ="tt" Table Row Cell >< Data ss:Type ="String" >Hello!World! </ Data ></ Worksheet Workbook >
