最简单的XML格式Excel表格文件

短命女 2022-06-12 07:50 173阅读 0赞

## [最简单的XML格式Excel表格文件][XML_Excel] ##

最简单的XML格式Excel表格文件

当然，还有几个地方是可以删除掉的内容，但是这样就有些破坏完整性了。这个文档的作用就是从XML数据源中导出数据之后，使用XSLT转换也可以把数据导出。简单！

![None.gif][] <? xml version="1.0" ?>  
![None.gif][] <? mso-application progid="Excel.Sheet" ?>  
![None.gif][] < Workbook  xmlns ="urn:schemas-microsoft-com:office:spreadsheet"   
![None.gif][] xmlns:o ="urn:schemas-microsoft-com:office:office"   
![None.gif][] xmlns:x ="urn:schemas-microsoft-com:office:excel"   
![None.gif][] xmlns:ss ="urn:schemas-microsoft-com:office:spreadsheet"   
![None.gif][] xmlns:html ="http://www.w3.org/TR/REC-html40" >  
![None.gif][]  < DocumentProperties  xmlns ="urn:schemas-microsoft-com:office:office" >  
![None.gif][]   < Title >Excel表格 </ Title >  
![None.gif][]   < LastAuthor >bigtall </ LastAuthor >  
![None.gif][]  </ DocumentProperties >  
![None.gif][]  < Styles >  
![None.gif][]   < Style  ss:ID ="Default"  ss:Name ="Normal" >  
![None.gif][]    < Alignment  ss:Vertical ="Center" />  
![None.gif][]    < Font  ss:FontName ="宋体"  x:CharSet ="134"  ss:Size ="12" />  
![None.gif][]   </ Style >  
![None.gif][]  </ Styles >  
![None.gif][]  < Worksheet  ss:Name ="tt" >  
![None.gif][]   < Table >  
![None.gif][]    < Row >  
![None.gif][]     < Cell  ss:MergeAcross ="6"   >< Data  ss:Type ="String" >Hello!World! </ Data ></ Cell >  
![None.gif][]    </ Row >  
![None.gif][]   </ Table >  
![None.gif][]  </ Worksheet >  
![None.gif][] </ Workbook >  
![None.gif][]

其实还可以精简到这样：

其实把名称空间定义html,o,x三个删除也好使！![teeth_smile.gif][]

[XML_Excel]: http://www.cnblogs.com/BigTall/archive/2004/10/13/51821.html
[None.gif]: /images/20220612/5bf3affc16fb4551b542ba64f548af82.png
[teeth_smile.gif]: /images/20220612/4ff28b6d03ef45cfb42c02ddca0dff4c.png