JETT 0.11.0 (Beta) Released
New in JETT 0.11.0:
View a history of all changes at the Change Log.
JETT (Java Excel Template Translator) is a Java 7 API that allows speedy creation of Excel spreadsheet reports using Excel spreadsheet templates.
JETT is built on top of the Apache POI library, which gives almost total control to the developer over the reading, creation, and modification of Excel spreadsheets. This includes the very tedious, verbose, and error-prone process of coding cell and text formatting, including font, color, highlighting, borders, alignment, header/footer, etc.
JETT is also built on top of the Apache Commons JEXL library (Java Expression Language), which allows expressions to be evaluated easily.
Additionally, JETT uses the jAgg library (Java Aggregations) to perform aggregate operations, such as Sum and Average, and super-aggregation operations, such as rollups and cubes, and display the calculations in the spreadsheet. It also uses jAgg to perform analytic operations, such as Lag, Lead, and RatioToReport.
JETT allows the developer to follow the MVC pattern easily. JETT is the Controller, the developer creates the Model, and either the developer or another party controls the Excel spreadsheet template, which acts as the View.
To summarize JETT, the developer supplies an Excel spreadsheet template, which provides the structure, layout, and styling of the resultant spreadsheet. Then, the developer creates beans that contain the actual data to be populated in the spreadsheet. Finally, the developer uses an ExcelTransformer, the JETT API entry point, to transform the template spreadsheet into the resultant spreadsheet, complete with the desired data, which can then be published.
JETT requires the following libraries: