JETT

Features

• 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.

Follow JETT

JETT Web Site