Java Programming

Hi All,

I'm trying to generate excel file using jxl api, and i'm running a sql query to generate data and send that data to jxl.Workbook.createWorkbook api. This is working fine if i have less data (ex: 10K rows with 15 columns) but if i've a big volume of data more than 100+K rows with 25 columns this api is failing with the following error:

ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError

I know there is a excel row limit for 2003 (65536), but can't we add worksheet dynamically and insert data into them?

Can some one please tell me how to generate excel file with large volume.

Thanks in advance!