JETT - Java Excel Template Translator

4.7 Stars (6)
3 Downloads (This Week)
Last Update:
Browse All Files


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.

JETT Web Site


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


Other Useful Business Software

Resolve application issues 65% faster Icon

Find and resolve application problems before they become incidents

Resolve application issues 65% faster Icon
Minimize application downtime by resolving application issues 65% faster. Monitor applications across on-premises, hybrid, and public cloud infrastructures from a single console. Set up intelligent application performance alerts to find and fix issues before they impact business services and end-users. Monitor 200+ applications from a single dashboard—no more wasting time between multiple tools and custom scripts.

User Ratings

ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 2 / 5
Write a Review

User Reviews

  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    We made extensive research and found this library as the best option to generate Excel spreadsheets from complicated templates. Really awesome!

    Posted 07/20/2015
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    It's much more powerful and flexible than jXLS.

    Posted 05/24/2014
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    A fairly decent library. Great Job Randy!

    Posted 05/01/2014
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    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.

    Posted 11/22/2013
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    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?

    Posted 09/08/2013
Read more reviews

Additional Project Details

Intended Audience

Developers, Information Technology

Programming Language




Thanks for helping keep SourceForge clean.

Screenshot instructions:
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks