aspose file tools*
The moose likes JSP and the fly likes Download it in different sheets in Excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Download it in different sheets in Excel" Watch "Download it in different sheets in Excel" New topic

Download it in different sheets in Excel

Mike Thomson
Ranch Hand

Joined: Nov 07, 2007
Posts: 115

I have a requirement to download the data from DB to CSV/Excel. What I did is retrieving all the records from DB and store in the List and pass that list to the jsp page. In JSP page, I am using the below setting to download it to CSV/EXCEL.

It was working fine. But I have an issues in it. Excel is capable of storing it only 65,536 rows.
Even all the data getting downloaded to CSV/excel (> 65,536), while saving I am getting error from excel saying that it can't save more than 65,536 rows and the below data won't be saved.

I am not opt for POI apache third party at this point of time.
Is it possible to download it in other sheets if it exceeds the max limit.

Example: Having data of around 100,000.

Download 65,536 - Sheet 1
Remaining in Sheet 2,3.. of the same excel.

Any idea/input/suggestion on it?
I agree. Here's the link:
subject: Download it in different sheets in Excel
Similar Threads
Downloading a multiple file from server
excel - how to put the semi colon seperated values in seperate columns
how to extract data to an xl sheet
Open excel in JSP
can we export the data from jsp page to a excel sheet with out a database hit