Excel information extraction based on XML metadata and schema

doi:10.3778/j.issn.1002-8331.2008.33.042

Computer Engineering and Applications ›› 2008, Vol. 44 ›› Issue (33): 135-137.DOI: 10.3778/j.issn.1002-8331.2008.33.042

• 数据库、信号与信息处理 • Previous Articles Next Articles

Excel information extraction based on XML metadata and schema

WANG Zhe,PAN Mao,GUO Yan-jun

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

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

王喆,潘懋,郭艳军

北京大学地球与空间科学学院，北京 100871

通讯作者: 王喆

Abstract

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

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

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

WANG Zhe,PAN Mao,GUO Yan-jun. Excel information extraction based on XML metadata and schema[J]. Computer Engineering and Applications, 2008, 44(33): 135-137.

王喆,潘懋,郭艳军. 基于XML元数据和Schema的Excel信息提取研究[J]. 计算机工程与应用, 2008, 44(33): 135-137.

[1]	LI Shundong, YOU Xiaoming, LIU Sheng. Dynamic Hierarchical Dual-Morphic Ant Colony Algorithm Based on Artificial Bee Colony Algorithm [J]. Computer Engineering and Applications, 2020, 56(12): 37-46.
[2]	LIN Bingdong1，2, ZHAO Danpu1，3, TAI Xianqing4. Design and Implementation of MooseFS Hot Standby Master [J]. Computer Engineering and Applications, 2019, 55(13): 72-77.
[3]	ZHU Xiangru1，2, LIU Bainian1，2, ZHANG Weimin1，2, CAO Xiaoqun1，2. General framework and component design of application platform for atmospheric reanalysis products [J]. Computer Engineering and Applications, 2018, 54(5): 223-230.
[4]	ZHENG Fengbin1, ZHU Qing1, 2, ZANG Wenqian2. Concurrent data flow model for remote sensing product driven by XML files [J]. Computer Engineering and Applications, 2018, 54(24): 266-270.
[5]	WEN Weidong1, LI Yang2, LI Wenhai2. Research on distributed storage with hybrid column-row strategy using Trevni [J]. Computer Engineering and Applications, 2018, 54(18): 74-81.
[6]	HAO Kun, XIN Junchang, HUANG Da, WANG Guoren. Decentralized model for distributed storage system [J]. Computer Engineering and Applications, 2017, 53(24): 1-7.
[7]	GUO Qianghui1, XU Zhao2, XIE Yuanfeng3. Study and implementation of automatic cable network schematic generation algorithms [J]. Computer Engineering and Applications, 2017, 53(24): 245-251.
[8]	YU Lianchang, ZHU Shenglin, LI Xujun. Design and implementation of genetic evaluation system for pigs based on XML [J]. Computer Engineering and Applications, 2017, 53(14): 251-256.
[9]	DING Qianglong, WANG Jin, ZHANG Xuejie. Research on ETL method of transforming relational data to graph data based on sub-schema [J]. Computer Engineering and Applications, 2017, 53(12): 76-84.
[10]	XU Peijuan, QI Fuhui, LI Zhuo, WANG Limin. Research of XML document similarity based on edit graph [J]. Computer Engineering and Applications, 2016, 52(2): 81-85.
[11]	WANG Chengyong, DU Qingwei, SUN Jing, SUN Zhen. Clustering XML documents based on feature order preference [J]. Computer Engineering and Applications, 2016, 52(12): 64-68.
[12]	YUAN Miao, WANG Xin. Deep Web schema matching frame based on sampling [J]. Computer Engineering and Applications, 2015, 51(3): 117-123.
[13]	HU Tiantian, CAO Min. Research of OWL ontology storage and query based on BaseX [J]. Computer Engineering and Applications, 2015, 51(24): 132-136.
[14]	ZENG Qiang1, LIU Liwei2, SHEN Ling3, WU Liyun1. Heuristic balancing schedule method for complicated assembly line of single product [J]. Computer Engineering and Applications, 2014, 50(7): 263-270.
[15]	YI Qi，JIA Jing, LU Yang, ZHANG Yu, HU Huaixiang. Research and realization of iSCSI protocol conformance testing [J]. Computer Engineering and Applications, 2014, 50(6): 77-82.

Excel information extraction based on XML metadata and schema

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

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics