jXLS - Excel Reports from XLS templates
A common requirement for many reporting applications is to provide the ability to export reports to Microsoft Excel format. This can be challenging for a number of reasons, including:
- Most reporting engines require the use of a report design tool to develop reports.
- Reports designed to be exported to PDF or HTML do not always translate well to XLS format.
- Advanced Excel functionality such as complex forumlas, macros, and charts are not always available through the reporting engines.
jXLS is an open source Java library that greatly simplies this process by providing the ability to use XLS templates as the basis for generating reports in Excel format.
jXLS is now fully integrated into OpenReports. OpenReports supports the use of jXLS templates as the ouput format for QueyReports. OpenReports also supports the use of embedded SQL in jXLS templates. This is a powerful feature that allow the generation of Excel reports containing the results of multiple queries. The OpenReports Tomcat distribution contains a number of Spreadsheet Report examples that illustrate the use of jXLS templates in OpenReports.
9 comments September 24th, 2006
