Hi,
I am using JXLS API to populate excel template. I have around 17000 rows and
100 columns for each row: This is code snippet I am using:
Connection con = ...// get connection
Statement stmt = con.createStatement();
String query = "SELECT * FROM employee";
ResultSet rs = stmt.executeQuery(query);
Map beans = new HashMap();
ResultSetCollection rsc = new
ResultSetCollection(rs, false);
beans.put( "employee", rsc );
XLSTransformer transformer = new
XLSTransformer();
transformer.transformXLS(
templateFileName, beans, destFileName);
But it fails saying out of memory , what should I do for such a large amount of
data. Please advice
Regards,
Navin
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
