【摘要】 数据仓库的数据来源于组织内部的OLTP系统和其它格式的内部、外部数据,它们之中的许多是按照Microsoft Excel格式予以组织的,如何通过ETL程序将该格式的数据转换成数据仓库中有用的信息是目前亟待解决的问题.首先叙述了Excel文件的结构和Java Excel API的使用方法,给出了Java读取Excel文档的操作步骤,结合实例说明了从Excel文件向数据仓库实现抽取及存储的过程和方法.更多还原

【Abstract】 The data in data warehouse are obtained from organization’s internal OLTP system and other format’s internal or external data,in which many of them are organized in Microsoft Excel format.It must be solved urgently at present that how to transform the Excel format’s data to the useful information of data warehouse.After analyzing the Excel document structure and Java Excel API application method,the operation approach of reading Excel document by Java program is discussed,and the process and strategies implementing and storing the Excel data to data warehouse are illustrated combined with an instance.更多还原