jXLS is a small and easy to use library that will enable you export Java beans to Excel using XLS template file.

Here are some key features of "jXLS":

· 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

Requirements:

· Java