Java中Excel操作类的设计与实现  

Design and implementation of controlling Excel in Java

作　　者：周亦敏[1] 张生[1] 

机构地区：[1]上海理工大学计算机工程学院,上海200093

出　　处：《上海理工大学学报》2007年第1期79-83,共5页Journal of University of Shanghai For Science and Technology

摘　　要：为解决Java应用程序中复杂报表的打印问题,提出了一种采用JNI和COM技术、在Java中操纵Excel实现强有力报表工具的方法.在Java中利用JNI与COM的通信方式,通过对Excel各COM对象的调用,完成在Java中对Excel的操作;同时将Excel的各COM对象映射为Java对象,调用自行设计开发的一组纯Java API,实现在Java中的复杂报表功能.首先描述了该方案提出的方法和功能,然后给出了系统构架,最后讨论了Java和VC++的实现代码.In order to handle the print problem in Java application, a novel method with Java native interface（JNI） and component object model（COM） technology to manipulate Excel in Java and its implementation are presented. In Java application, the communication between JNI and COM, is put into effect through calling COM objects in Excel to complete the Excel manipulation. Further more, each COM object is mapped into Java object and the self designed pure-java API is called to implement complex reports form in Java application. The motivation and functions of the presented system are described, and the system architecture is provided. The implementation of Java with VC ＋ ＋ code is also discussed.

关 键 词：JAVA应用程序 EXCEL 平台相关接口 组件对象模型 

分 类 号：TP274[自动化与计算机技术—检测技术与自动化装置]