An easy-to-use Java library for generating Excel files using XLS templates
jXLS is small and easy-to-use Java library for generating Excel files using XLS templates. Also jXLS can be used to read XLS files and populate Java beans with Spreadsheet data according to XML configuration file

Main Features

* Using SQL queries directly in XLS templates
* Simple property access notation
* Full expression language support
* Complex object graph export
* Flexible collection export
* Flow-Control Tags support
* Dynamic grouping of data
* Export of a single collection into multiple worksheets
* Adjacent tables support!
* Complex formulas support
* Charts, Macros and many other Excel features in XLS Template
* Dynamic Outlines
* Dynamic Columns Hiding
* Dynamic Cell Style processing through custom Processors
* JDBC ResultSet export
* Merged Cells support
* Multiple bean properties in a single cell
* Reading XLS files

In your XLS template you can use any Excel features which are preserved by Jakarta POI when reading and writing XLS files. Particularly it means you can use Charts and Macros in your XLS template and many other features you can free download jXLS 0.9.8 now.