How to handle excel generation with more than 1,048,576 rows

[ankurkumarHL]

Hi, We have cases where we need to generate excel with more than 1,048,576 rows. We have tested is and jxls just ignored all the rows more than 1,048,576. Is there any way to create new sheet where a sheet is overflow. How to handle this?

[SoltauFintel]

1M rows is the limit of Microsoft Excel.

[ankurkumarHL]

@SoltauFintel is there any support in jxls in which if records overflow a sheet then it will create a new sheet in the same excel and populate rest of the records in new sheet and so on?

[SoltauFintel]

Please have a look at http://jxls.sourceforge.net/reference/multi_sheets.html and/or clone our repo and look for examples.

You must limit the lists. Jxls does it not for you.