结合JXLS和POI技术开发Web报表

Through A Combination of JXLS and POI to Achieve the Development of Web Report

传统的Web报表开发方法是采用iReport和jasperReport相结合的方式，但该方式需要人工绘制报表。当系统报表结构复杂且客户已提供Excel报表模板时，重复的人工绘制无疑延长了系统开发时间。针对这种情况，一个利用已有模板来生成Excel报表的Java开源包—JXLS发挥了其不可替代的优势。探讨如何使用JXLS开发Excel报表，并阐述JXLS技术的优势和创新点。并通过Jakarta POI的HSSF接口弥补JXLS的不足，使得二者结合来生成完美报表。

The traditional method for the development of report is the combination of jasper Report and iReport, but the approach requires manual mapping report template. In view of this situation, a java open-source package-JXLS which use an existing report template to generate the Excel reports play its irreplaceable advantages. This article will explore how to use JXLS to achieve development of Excel reports and make up for deficiencies of JXLS through the use of HSSF interface.