File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Open Source Projects and the fly likes data from data base to excel in servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "data from data base to excel in servlet" Watch "data from data base to excel in servlet" New topic
Author

data from data base to excel in servlet

carina caoor
Ranch Hand

Joined: Jun 23, 2007
Posts: 300

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..
Vicky Vijay
Ranch Hand

Joined: Apr 23, 2008
Posts: 125
Try this,

JEXCEL API
carina caoor
Ranch Hand

Joined: Jun 23, 2007
Posts: 300

Does this supports xlsx file. ALso will it handle java heap space error if the file is too large...
Vicky Vijay
Ranch Hand

Joined: Apr 23, 2008
Posts: 125
It supports the following format,


Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks
Reads and writes formulas (Excel 97 and later only)
Generates spreadsheets in Excel 2000 format


Check this FAQ - (How do I get rid of OutOfMemory exceptions?)

http://jexcelapi.sourceforge.net/resources/faq/
Tim Moores
Rancher

Joined: Sep 21, 2011
Posts: 2408
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).
carina caoor
Ranch Hand

Joined: Jun 23, 2007
Posts: 300

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
Tim Moores
Rancher

Joined: Sep 21, 2011
Posts: 2408
I'm having a bit of a hard time understanding that it stops without any exception.
carina caoor
Ranch Hand

Joined: Jun 23, 2007
Posts: 300

did anybody try Aspose? does it supports heavy data around 50k or more rows witing to excel 2007 files.... please suggest.
 
 
subject: data from data base to excel in servlet
 
Similar Threads
reading from excel files
Alignment issue while Export data to Excel file from a jsp
Download it in different sheets in Excel
generate large XLS file using java
Exporting data to excel file... using java web app