Stack Overflow
Stack Overflow

Questions tagged [jett]

JETT - Java Excel Template Translator - an open-source Java library that creates Excel spreadsheets by publishing data to template spreadsheets.

JETT, or Java Excel Template Translator, is an open-source Java library that creates Excel spreadsheets by publishing data to template spreadsheets. It uses Apache POI for spreadsheet manipulation and Apache Commons JEXL for its expression language capability.

To use JETT, the user creates an Excel template spreadsheet first. In Java code, the user obtains data through any means, creates a Map of bean names to bean values, and uses an ExcelTransformer object to publish the data to the resultant Excel spreadsheet.

For more information, see the project webpage.

20 questions
11
votes
1 answer

Does POI XSSF still have crazy bad memory issues?

A couple years ago, I ran into issues where I was creating large excel files using jXLS and POI XSSF. If my memory is correct, I think XSSF would create something like 1GB+ temp files on the disk to create 10mb excel files. So I stopped using jXLS…
Bob Thule
  • 691
  • 9
  • 15
2
votes
1 answer

Jett : Excel Templating in Java : cloning sheets that contain charts

I posted this on the Jett user mailing list but no response in over a month. Here is the question I see that on your site you have: Beans on a Per-Sheet Basis/Cloning Sheets http://jett.sourceforge.net/transformation/sheet_specific_beans.html If a…
Palu
  • 668
  • 3
  • 11
  • 26
1
vote
1 answer

How to use JETT if tag to compare strings

I am using JETT's if tag to format an Excel file. I want to use the below condition to compare a string. I have an apple. However, my Excel sheet keeps running into a TagParseException where…
biancang
  • 43
  • 2
  • 10
1
vote
1 answer

How to duplicate main loop data within JETT?

I'm developing Excel report with hierarchy data. Using JETT (java excel template translator) and I'd like to duplicate rows from the main loop when there are collection of collection. Here is a brief example. public class JettTest { @Test …
Andriy Slobodyanyk
  • 1,965
  • 14
  • 15
1
vote
0 answers

JETT HOW TO CONFIGURE DATA FROM A SPREADSHEET TO OTHER

I Have two spreadsheet both with diferrent data. In one of the spreadsheet i want a specific colum from the other. This is the original code for the spreadsheet (acrruals)i want to add the colum: ${accruals.employee.name} This is the other…
Stefano Encarnacion
  • 11
  • 1
1
vote
1 answer

Excel template translator Jett more data auto generated sheet

Using jett template translator if there exist more data than supported in one sheet. Will more data displayed in next sheet . If yes will it include header of table.
anjana
  • 67
  • 2
  • 9
1
vote
1 answer

How to fix corrupted xls file by maven?

I have a method of generating report made with jett: try { InputStream inPath = ProdutoManagedBean.class.getResourceAsStream("/template.xls"); ExcelTransformer transformer = new ExcelTransformer(); …
philabreu
  • 55
  • 1
  • 7
1
vote
1 answer

Jxls or Jett: How to render a tree with formulas on parent nodes?

Is there a way to generate a report for a hierarchical tree using JXLS (or JETT)? For example the model is something like: -node1 --node11 --node12 ---node121 ---node1211 --node13 -node2 I need to render the result with two columns: | node name |…
Fanfy
  • 11
  • 2
0
votes
1 answer

Error 500 when exporting to Excel with jett

When I export Excel with jett I get this error. I lost a few days because of it Maven: org.apache.poi …
Nqt Bean
  • 3
  • 4
0
votes
0 answers

Excel JETT Page Orientation

Does JETT support page orientation? When printing portrait the report spans two pages. When printing landscape the report spans one page and this the desired results.
Lionel
  • 3
  • 2
0
votes
2 answers

Does JETT support multiple IF statements?

I am using JETT to transform some Excel sheet documents. I need to apply conditional formatting inside . This is my code inside spreadsheet document cell:
Mirecc41
  • 21
  • 4
0
votes
1 answer

JETT Template engine is not supporting the List of collections instead it supports List of Java Entity classes

I was using JETT Template engine for report generation. The JETT Template engine supports the below format of input. Map beans = new HashMap(); ValueObject beanName = new ValueObject(); beanName.setProperty("Hello,…
Aravindh RS
  • 73
  • 1
  • 3
  • 13
0
votes
1 answer

How to use tag with nested ?

I got parse error exception when I try to use with nested . Can Span tag use along with nested loop? Subunit | Fiber …
Tuong Luong
  • 33
  • 1
  • 9
0
votes
1 answer

Excel template translator JETT to append data to workbook based on template

I am using JETT to generate xls from xls template. My input data will be given in pages is there way to append data to sheet as well applying template from input xls to output workbook using Jett api's
anjana
  • 67
  • 2
  • 9
0
votes
1 answer

How to pass HashMap to forEach tag in xls generated by jett?

I have a Map in managed bean private Map> fichasTecnicasOperacaoResumo; that reference to entity FichaTecnica: public class FichaTecnica{ //... private Set operacoes; } which I…
philabreu
  • 55
  • 1
  • 7
1
2