JETT Icon

JETT

beta

JETT - Java Excel Template Translator

4.7 Stars (6)
2 Downloads (This Week)
Last Update:
Download jett-0.10.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.

KEEP ME UPDATED

Other Useful Business Software

The Sight of Sound Icon

­ Improve VoIP Visibility from SIP to RTP

The Sight of Sound Icon
Cloudbased voice solutions are common in enterprise networks and frustrating for operations teams to manage. Simplify VoIP monitoring by having a proactive analysis of on-prem, hybrid and UCaaS voice services. Try the ThousandEyes VoIP monitoring solution today, free.

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

Java

Registered

2012-01-30

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
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
X

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.

No, thanks