Hi, i am using APache POI XSSF to create an xlsx file , and have selected few column from a table and writing it down in the excel. As the rows returned are more than 10000 , the excel created writes only 8000 rows into it and abrubtly stops without saving the file in temporary location. I want to write large dataset from database to excel .. which API do i need to use... please suggest..
Isn't there an exception of some kind? I'm fairly certain that there is no intrinsic limit of 8000 rows; maybe a memory problem if you also have many columns (POI is kind of a memory hog). The only other free API I'm aware is jExcelApi, and that doesn't support XLSX, only XLS.
If the exception is indeed a memory problem, just give the JVM more to work with (-Xms -Xmx).
Itried increasing the jvm memory through -Xmx and -Xms.. but it writes only to certain rows like around 8k or 10k.. and stops abrubtly... Does JExcel API writes to XLS files with out any problem though the file size may be around 50k