JETT is a Java 5.0 API that reads an Excel spreadsheet as a template, takes your data, and creates a new Excel spreadsheet that contains your data, formatted as in the template. It works with .xls and .xlsx template spreadsheets.
- Supports transformation of Excel 97-2003 (.xls) and Excel 2007+ (.xlsx) template spreadsheets.
- Integration with Apache Commons JEXL allows easy creation and evaluation of Expressions.
- Integration with SourceForge's jAgg project to extend JEXL with Aggregate Expressions.
- Built on the Apache POI library to manipulate Excel spreadsheets.
- Built-in Tag Library allows XML-like tags to allow programming-like constructs such as "ForEach" and "If".
- Looping Tags support "copy down" and "copy right" behavior.
- Custom Tag Libraries may be coded and supplied for execution.
- The CellListener interface allows custom processing of Cells.
- Merged cell regions, row heights, and column widths are respected.
- Like Apache POI, existing Excel features are kept intact, like Charts and Macros.
- Template Sheets may be cloned and processed in a loop.
- Multiple Collections may be implicitly processed in a loop.
- Adjacent, or side-by-side, display of Collections is supported.
- Rich Text Strings formatting is respected, even in Cells with Expressions.
- POI Objects are exposed, representing the Cell, Sheet, and Workbook objects.
- Excel formula generation support.
- JDBC execution of queries directly from the template spreadsheet.
We made extensive research and found this library as the best option to generate Excel spreadsheets from complicated templates. Really awesome!
It's much more powerful and flexible than jXLS.
A fairly decent library. Great Job Randy!
Excellent library. We use it with hugely complex templates with tens of sheet, Excel 2003 compatibility, and tortured styling, and it holds the load, and is even fast ! Jett has limits, that are always connected to the underlying Apache POI API, but it is THE product if you want simple enough reports for no cost and a little dev time.
Very nice idea! I'm a jxls user, but your api looks more flexible. unfortunatly i can't yet figure out how to use jett because i massly use SQL Execution in the Template so to write everything i need directly in Excel. I look forward to see how tris feature Will be implemented, Will it?