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

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

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

<? xml version="1.0" ?>
<? ">?>
< 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" >
  < DocumentProperties  xmlns ="urn:schemas-microsoft-com:office:office" >
   < Title > Excel表格 </ Title >
   < LastAuthor > bigtall </ LastAuthor >
  </ DocumentProperties >
  < Styles >
   < Style  ss:ID ="Default"  ss:Name ="Normal" >
    < Alignment  ss:Vertical ="Center" />
    < Font  ss:FontName ="宋体"  x:CharSet ="134"  ss:Size ="12" />
   </ Style >
  </ Styles >
  < Worksheet  ss:Name ="tt" >
   < Table >
    < Row >
     < Cell  ss:MergeAcross ="6"  >< Data  ss:Type ="String" > Hello!World! </ Data ></ Cell >
    </ Row >
   </ Table >
  </ Worksheet >
</ Workbook >

其实还可以精简到这样：

<? xml version="1.0" ?>
<? ">?>
< 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 ="tt" >
   < Table >
    < Row >
     < Cell >< Data  ss:Type ="String" > Hello!World! </ Data ></ Cell >
    </ Row >
   </ Table >
  </ Worksheet >
</ Workbook >

其实把名称空间定义html,o,x三个删除也好使

转载于:https://www.cnblogs.com/chenqingwei/archive/2009/10/21/1587549.html