Excel template translator Jett more data auto generated sheet

222 Views Asked by At

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.

1

There are 1 best solutions below

0
On

No, it won't.

Since you're mentioning max rows per sheet limit, I assume you're working with the XLS format where every sheet is limited to 65536 rows. Then I would strongly advise you to switch to XLSX format, since its limit is around 1 million rows per sheet.

Also, if you're inserting so much data per sheet, you should consider streaming the data directly to the sheet using SXSSF POI API. If you manipulate huge XLSX spreadsheets with hundreds of thousands of rows directly with JETT, you're likely to hit memory problems - but because of POI XSSF, not because of JETT itself.

If you're stuck with XLS format, you'll have to do the pagination and insert extra sheets yourself before inserting data with JETT.