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.

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.

Project Activity

See All Activity >

License

GNU Library or Lesser General Public License version 3.0 (LGPLv3)

Follow JETT

JETT Web Site

Other Useful Business Software
The ultimate small business management platform Icon
The ultimate small business management platform

LionO360 is a comprehensive SAAS based CRM/ERP solution that enables you to manage your entire business from one unified platform.

Everything you need to run your business – all in one place, speaking the same language. LionO360 is business solutions brought to life.
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
4
2
0
0
0
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

User Reviews

  • 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?
Read more reviews >

Additional Project Details

Intended Audience

Information Technology, Developers

Programming Language

Java

Registered

2012-01-31