<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent posts to Discussion</title><link href="https://sourceforge.net/p/jett/discussion/" rel="alternate"/><link href="https://sourceforge.net/p/jett/discussion/feed.atom" rel="self"/><id>https://sourceforge.net/p/jett/discussion/</id><updated>2022-11-08T01:35:30.622000Z</updated><subtitle>Recent posts to Discussion</subtitle><entry><title>SXSSFWorkbook</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/8500a610/?limit=25#41b0" rel="alternate"/><published>2022-11-08T01:35:30.622000Z</published><updated>2022-11-08T01:35:30.622000Z</updated><author><name>Etienne Canaud</name><uri>https://sourceforge.net/u/etiennecanaud/</uri></author><id>https://sourceforge.netf906059fc388b69dd613be2d18349d923fffbdec</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Subham,&lt;/p&gt;
&lt;p&gt;Are you sure this is related to JETT? JETT only works with HSSF (xls) and XSSF (xslx) workbooks as far as I can tell, it doesn't support streamed generation of XSLX workbooks as it needs the whole document in memory for manipulation when filling the template. &lt;br/&gt;
This looks like a pure SXSSF question, so you may not be on the right forum, you should ask on POI forums - or on StackOverflow. If this is JETT related, please share you code so that we can give it a try and better understand what's going on. &lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>SXSSFWorkbook</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/8500a610/?limit=25#db23" rel="alternate"/><published>2022-11-07T08:18:45.580000Z</published><updated>2022-11-07T08:18:45.580000Z</updated><author><name>Shubham</name><uri>https://sourceforge.net/u/shubham1562/</uri></author><id>https://sourceforge.net533b72ac8291390fbdcdc58bb66e9335ccbdf0a5</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi, I am using SXSSF workbook for excel exports, in a particular case I have to use hyperlink in a cell along with cellStyle.&lt;/p&gt;
&lt;p&gt;However, in exported files if I set both the properties (i.e hyperlink and cellStyle) then cellStyle property is ignored and hyperlink text is displayed with default styling. Is this a known issue?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>New JETT Version</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/c3a2498819/?limit=25#a24b" rel="alternate"/><published>2022-09-07T15:55:21.282000Z</published><updated>2022-09-07T15:55:21.282000Z</updated><author><name>tran4o</name><uri>https://sourceforge.net/u/tran4o/</uri></author><id>https://sourceforge.net8d59a67f73010b94950db0a0cf5eab9f9cb2254e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi, i made an github repo containing the last version with updated dependencies (poi5 + commons-jexl3). Almost all tests pass, still not used in production so further work may be needed. &lt;/p&gt;
&lt;p&gt;&lt;a href="https://github.com/plan-vision/jett" rel="nofollow"&gt;https://github.com/plan-vision/jett&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>New JETT Version</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/c3a2498819/?limit=25#72c8" rel="alternate"/><published>2021-12-17T13:12:39.339000Z</published><updated>2021-12-17T13:12:39.339000Z</updated><author><name>SuperPat</name><uri>https://sourceforge.net/u/superpat45/</uri></author><id>https://sourceforge.net45b9eceeb23d2863d2394c51543e7b502cf47c0e</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;This project really need an active github fork.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Upgradation of apache poi version in jett</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/aa8db9af02/?limit=25#94ca" rel="alternate"/><published>2021-09-11T18:48:16.077000Z</published><updated>2021-09-11T18:48:16.077000Z</updated><author><name>Brian Cullen</name><uri>https://sourceforge.net/u/briancullen/</uri></author><id>https://sourceforge.netfdcb333a687341b10ecc72f16c88da6d7575df60</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;As mentioned in another post I have made a pull request on github to update the version of poi. I'm going to see if I can get the maintainer to allow me to merge it into the main repo.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>New JETT Version</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/c3a2498819/?limit=25#4507" rel="alternate"/><published>2021-09-11T18:46:10.833000Z</published><updated>2021-09-11T18:46:10.833000Z</updated><author><name>Brian Cullen</name><uri>https://sourceforge.net/u/briancullen/</uri></author><id>https://sourceforge.net7efde9350aff0b6bde80e75e8650f59abf828174</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I ran into the same issue so have made a pull request on the github repository with a version that seems to work with POI version 5.0 if that is of use to anyone. I'm going to see if I can get it merged into the main repo otherwise I might just publish it as a separate artifact.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Paginated data support for jett</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/c5a75003f2/?limit=25#6f77/3544" rel="alternate"/><published>2021-06-25T08:16:23.845000Z</published><updated>2021-06-25T08:16:23.845000Z</updated><author><name>Souvik Chakraborty</name><uri>https://sourceforge.net/u/souvikch/</uri></author><id>https://sourceforge.net7032fd97984b3e963b9bc99cf2bb33531a47ce88</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Thanks Etienne for the response. I have tried out the sxssf API and  the merging capabilities works great for my use case.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Paginated data support for jett</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/c5a75003f2/?limit=25#6f77" rel="alternate"/><published>2021-05-25T13:37:40.568000Z</published><updated>2021-05-25T13:37:40.568000Z</updated><author><name>Etienne Canaud</name><uri>https://sourceforge.net/u/etiennecanaud/</uri></author><id>https://sourceforge.netab860157af375e8365ad8bc5a8e5a1d6cd4db5bb</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;JETT will read all the data to fill it in the template, so you will need to "wrap" your paginated data in a Collection first before passing it to JETT to generate the Excel file. This could be as simple as retrieving all your data (page after page) and put it in a single List, but you might also wrap it in a custom class that will iterate over the pages without having to load everything in memory at once.&lt;/p&gt;
&lt;p&gt;That being said, since JETT is based on  "Standard" POI API, it means that even if your data is paginated, the generated Excel file will be stored as one big XSSF document in memory, so you must ensure that the generated workbook size will not exceed the available memory. With XSSF, this size can grow very fast - a good estimate is to take your xlsx file, rename it to zip, unzip it, and look at the size of the extracted XML files.&lt;/p&gt;
&lt;p&gt;From my experience JETT works really well if you have a few thousands of rows - eventually a few tens of thousands if the template is not overly complicated.&lt;br/&gt;
However, if you need to generate huge spreadsheets with hundreds of thousands of rows, you'll need to use POI Streamed XSSF API (SXSSF: &lt;a href="https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/streaming/SXSSFWorkbook.html" rel="nofollow"&gt;https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/streaming/SXSSFWorkbook.html&lt;/a&gt;) and insert the data yourself.&lt;/p&gt;
&lt;p&gt;One approach that I've leveraged for very large spreadsheets is that I first render the document  using JETT - and can thus leverage all the features and flexibility of JETT - to generate all the headers and structure of the spreadsheet, but I don't insert the data. I only insert some placeholders on the last line of spreadsheets where very large amounts of data have to be inserted. Once this is done, I take the generated POI document, and edit it with SXSSF to insert the rows at the end of the sheets. This approach scales very well and allows to reach XLSX limit (1 million row per sheet) with acceptable performance and minimal memory usage.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>cell style of a currency cell </title><link href="https://sourceforge.net/p/jett/discussion/general/thread/aa70f71919/?limit=25#9008" rel="alternate"/><published>2021-05-19T08:20:14.636000Z</published><updated>2021-05-19T08:20:14.636000Z</updated><author><name>Giu Fus</name><uri>https://sourceforge.net/u/giufus/</uri></author><id>https://sourceforge.netb401607098455627d77ca6f350c8ae9ce31901a3</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi, &lt;/p&gt;
&lt;p&gt;I cannot set the style of a cell containing a replaced value (${myObj.offerValue} a float).&lt;br/&gt;
The cell has its own dataFormat, that is maintained and the bg color too, but the style of the font is changed and I don't find a way to override it.  I tried :&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&amp;lt;jt:style style....&lt;/li&gt;
&lt;li&gt;&amp;lt;jt:style class....&lt;/li&gt;
&lt;li&gt;${{ sheet.getRow(11).getCell(2).setCellStyle(sheet.getRow(11).getCell(1).getCellStyle()); }}&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;Same thing with a Date value, I solved changing the type from Date to LocalDate. &lt;/p&gt;
&lt;p&gt;Suggestions?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>New JETT Version</title><link href="https://sourceforge.net/p/jett/discussion/general/thread/c3a2498819/?limit=25#e40e" rel="alternate"/><published>2021-05-18T00:48:22.826000Z</published><updated>2021-05-18T00:48:22.826000Z</updated><author><name>Etienne Canaud</name><uri>https://sourceforge.net/u/etiennecanaud/</uri></author><id>https://sourceforge.net26e3a916406d2636964346048ddb90d1c44a08e4</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi Anjana,&lt;/p&gt;
&lt;p&gt;I really hope that we could get Randy Gettman's answer on this but unfortunately he's been really quiet since the last JETT version was released 3 years ago (0.11). You can still find JETT'ers to answer your questions though, either on this forum or on Stackoverflow.&lt;/p&gt;
&lt;p&gt;There's no sign that this project will get a new release any time soon, but that shouldn't be completely blocking you from considering it for your project. The source code is well written and there's good unit testing if you're not afraid of getting your hands dirty in the rare cases where something goes wrong. I've been using JETT for years already, and so far it's been proving extremely useful and reliable. &lt;/p&gt;
&lt;p&gt;Now, if you're looking at other options for Excel Templating in Java that are still actively maintained, you may want to look at JXLS. The version 1 was (in my humble opinion) vastly inferior to JETT, but since then they've completely rewritten the code in version 2.0 and have addressed most of the design issues - as well as introduced some really nice improvements. For example, putting tags in cell comments makes template much easier to read. I feel that the JETT/JXLS comparison provided at &lt;a href="http://jett.sourceforge.net/jxls_comp.html" rel="nofollow"&gt;http://jett.sourceforge.net/jxls_comp.html&lt;/a&gt; should be refreshed to take all the latest JXLS improvement into account, so don't just base your decision solely on it. &lt;br/&gt;
That being said I don't have any experience of using JXLS 2+ in production (&lt;em&gt;unlike with JETT&lt;/em&gt;), so take this with a pinch of salt.&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>