【摘要】 Microsoft Excel文档是ODS(Operational Data Store,操作型数据仓)的重要数据来源,同时ODS中的数据也需要按照Excel文件格式输出,而Excel的专有文件格式使其与ODS进行数据交换时存在一定困难。在分析Excel文件结构和Jakarta POI-HSSF(Poor Obfuscation Implementation&Horrible Spread Sheet Format)功能基础上,详细描述了基于Java的Excel文档与ODS之间进行数据交换的方法,并介绍了实际实现过程中应注意的事项。更多还原

【Abstract】 Microsoft Excel documents are important data source of ODS,and the data stored in ODS need to be derived in Excel file formats,however the special format of Excel file makes it difficult to exchange data with ODS.After analyzing the structure of Excel file and functions of Jakarta POI-HSSF(Poor Obfuscation Implementation & Horrible Spread Sheet Format),the data exchanging approach between Excel document and ODS based on Java is discussed in detail,and some attentive issues in data exchanging are introduced.更多还原