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
0
votes
1 answer

How to resolve InvalidFormatException in xls file generated by jett?

I have a bean with method to generate report made with jett: Map beans = new HashMap(); beans.put("fichasTecnicasMateriaPrimaResumo", fichasTecnicasMateriaPrimaResumo); try { InputStream inPath =…
philabreu
  • 55
  • 1
  • 7
0
votes
0 answers

How to solve ioexception in xls file generated by jett?

I have a bean with method to generate report made with jett: beans.put("list", list); try { String inPath = ("/template.xls"); ExcelTransformer transformer = new ExcelTransformer(); transformer.transform(inPath,…
philabreu
  • 55
  • 1
  • 7
0
votes
1 answer

JETT loop 1, 2, 3, 4, 5 for each row

I use Tag to loop but I want add a column to return row number such as: 1, 2, 3, 4, 5 Example 1 fldTest1 fldTest2 2 fldTest1 fldTest2 3 fldTest1 fldTest2 4 fldTest1 fldTest2 .... Row number starts from 1 and count++ Thanks…
0
votes
1 answer

detecting and replacing variables in a string by values

I have an excel sheet whose first column contains following data "What is ${v1} % of ${v2}?", two more columns (v1 and v2) in this sheet contains {"type":"int", "minimum":15, "maximum":58} and {"type":"int", "minimum":30, "maximum":100}, these are…
Sandeep
  • 13
  • 1
  • 2
  • 10
0
votes
1 answer

Jett, poi, jexl. Cannot transform my document

I'm trying to transform my workbook with Jett like this: HashMap tm = new HashMap(); tm.put("mod", "123"); ExcelTransformer t = new ExcelTransformer(); t.transform(wb, tm); In the document there is a cell with such…
Pavel
  • 53
  • 8
1
2