File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Export JSP page to different worksheet of Excel Document Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Export JSP page to different worksheet of Excel Document" Watch "Export JSP page to different worksheet of Excel Document" New topic
Author

Export JSP page to different worksheet of Excel Document

Aravind Prasad
Ranch Hand

Joined: Dec 28, 2005
Posts: 265
Dear Ranchers.
I'm doing a project in JSP and Oracle. In that i'm classifying the status of the consignment by giving a boolean column in the table. four types of status are there in the transactions

1) Not Shipped
2) In Transit
3) Cleared in Port
4) Delivered

The status will change according to the date when it is updating

While exporting all the datas to excel, my client needs it to in seperate worksheets. Is that possible. If so means how should id do that..

For exporting to excel i'm using the following code..


All the datas are properly exported in to excel sheet now..
I want to classify them by the status and put the datas into appropriate Worksheets..

Please help me.. rachers..

regards

Aravind Prasad
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Export JSP page to different worksheet of Excel Document