Nov 27, 2011 at 1:26 PM
Edited Nov 27, 2011 at 1:27 PM
Without knowing a lot more detail about the structure of your code, it's almost impossible to answer this. There has been a lot written on this forum about performance such as
this thread, or
Use fromArray() where possible, rather than setting values for individual cells; when setting styles, use applyFromArray(), and set styles for a range of cells rather than for each individual cell; make use of the fluent interface; set setPreCalculateFormulas(false) when
After some code update and replacing cache instructions by
I do export in just 10-12 seconds (to build 1.5Mb Excel5 file). It is much much better than it was at the beginning.
After that I tried to switch to fromArray() to gain performance but got nothing.