This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 263
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Export JSP page to different worksheet of Excel Document
 
Similar Threads
Save a webpage as PDF or Excel file
How to get http header infomation in HttpURLConnection
Problems while exporting jsp to excel
The chart problem
Open JSP File in Excel with Tabs