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
What's New in This Release: [ read full changelog ]
· Bug-fixes for processing multiple tags in a single row (jxls-core)
· Fixed a bug with grouping in forEach tag (jxls-core)
· Support for the missing primitives and java.lang.BigInteger (jxls-core)