Excel文档XML格式

以下是Excel的XML的数据格式,文件的后缀为.xls

 

<?xml version="1.0" encoding="gb2312" ?>
<?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">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Created>1996-12-17T01:32:42Z</Created>
<LastSaved>2011-01-11 00:00:00</LastSaved>
<Version>11.6568</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<RemovePersonalInformation/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>4530</WindowHeight>
<WindowWidth>8505</WindowWidth>
<WindowTopX>480</WindowTopX>
<WindowTopY>120</WindowTopY>
<AcceptLabelsInFormulas/>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
</Styles>
<Worksheet ss:Name="表2">
<Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="9" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Row><Cell><Data ss:Type="String">会员卡号</Data></Cell>
<Cell><Data ss:Type="String">注册城市</Data></Cell>
<Cell><Data ss:Type="String">手机号码</Data></Cell>
<Cell><Data ss:Type="String">标注次数</Data></Cell>
<Cell><Data ss:Type="String">标注城市</Data></Cell>
</Row>
<Row><Cell><Data ss:Type="String">00000427</Data></Cell><Cell><Data ss:Type="String">太原</Data></Cell><Cell><Data ss:Type="String">18665318384</Data></Cell><Cell><Data ss:Type="Number">13</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">00000000</Data></Cell><Cell><Data ss:Type="String">太原</Data></Cell><Cell><Data ss:Type="String">15446565666</Data></Cell><Cell><Data ss:Type="Number">3</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">00000012</Data></Cell><Cell><Data ss:Type="String">太原</Data></Cell><Cell><Data ss:Type="String">13510521294</Data></Cell><Cell><Data ss:Type="Number">3</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">00000019</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell><Cell><Data ss:Type="String">13510597561</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">00000012</Data></Cell><Cell><Data ss:Type="String">昆明</Data></Cell><Cell><Data ss:Type="String">15012830746</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">00000844</Data></Cell><Cell><Data ss:Type="String">太原</Data></Cell><Cell><Data ss:Type="String">14455688855</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">00000007</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell><Cell><Data ss:Type="String">15820418236</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
<Row><Cell><Data ss:Type="String">00000310</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell><Cell><Data ss:Type="String">15073013266</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell><Data ss:Type="String">深圳</Data></Cell></Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><Selected/><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet>
</Workbook>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值