计算机工程与应用 ›› 2008, Vol. 44 ›› Issue (33): 135-137.DOI: 10.3778/j.issn.1002-8331.2008.33.042

• 数据库、信号与信息处理 • 上一篇    下一篇

基于XML元数据和Schema的Excel信息提取研究

王 喆,潘 懋,郭艳军   

  1. 北京大学 地球与空间科学学院,北京 100871
  • 收稿日期:2008-05-07 修回日期:2008-06-04 出版日期:2008-11-21 发布日期:2008-11-21
  • 通讯作者: 王 喆

Excel information extraction based on XML metadata and schema

WANG Zhe,PAN Mao,GUO Yan-jun   

  1. School of Earth and Space Sciences,Peking University,Beijing 100871,China
  • Received:2008-05-07 Revised:2008-06-04 Online:2008-11-21 Published:2008-11-21
  • Contact: WANG Zhe

摘要: 针对地质工作单位中使用的复杂格式的Excel报表中的信息同数据库之间转储的困难,提出了采用XML语言描述的元数据模型来辅助表达Excel报表中的信息。使用XML Schema定义XML元数据语法,使得基于元数据的应用程序来提取Excel报表中信息变得更加灵活通用。

关键词: 可扩展标记语言(XML), Excel, Schema, 元数据

Abstract: For the dump difficulty from complex Excel report forms using by mining enterprises and databases,bring forward the use of XML as the metadata model language to describe the information in Excel report.In addition,the use of XML Schema definition of XML metadata syntax,making applications based on meta data to extract information in Excel reports become more flexible and general.

Key words: Extensible Markup Language(XML), excel, schema, metadata