JETT

beta

JETT - Java Excel Template Translator

4.6 Stars (5)
11 Downloads (This Week)
Last Update:
Download jett-0.7.0-distr.zip
Browse All Files

Description

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

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.

Update Notifications





User Ratings

★★★★★
★★★★
★★★
★★
3
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
Write a Review

User Reviews

  • mercichao
    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
  • mvejvoda
    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
  • xpierro
    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
  • darkangelvp
    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
  • donghwilee
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    I had a few long lasting problems with xlsx format with jxls. I have tested with those reports with jett and all problems are gone. The transition was easy too.

    Posted 08/15/2013
Read more reviews

Additional Project Details

Intended Audience

Developers, Information Technology

Programming Language

Java

Registered

2012-01-30
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.