Performances

Performance

Since you might have to face foolish requests like exporting hundreds of thousands of rows in a few seconds, I added some speed tests. There are 2 options that may dramatically slow down generation process on huge datasets:

• adjustColumnWidth
• evaluateCellFormulas

Both available into MempoiBuilder they could block your export or even make it fail. Keep in mind that if you can't use them for performance problems you could ask in exchange for speed that columns resizing and cell formula evaluations will be hand made by the final user.

The best performance choice between the available Workbook descendants is the SXSSFWorkbook.