File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes JSP and Excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "JSP and Excel" Watch "JSP and Excel" New topic

JSP and Excel

Tom Connors

Joined: Mar 08, 2006
Posts: 1
I submit a JSP page from a Javascript function that displays data and has two hyperlinks. One generates an Excel spreadsheet (using HSSF) and the other returns to the JSP it just came from (It's a criteria selection screen).

My problem is when I select the "Generate Spreadsheet" (which submits another JSP containing the HSSF code), the spreadsheet is generated but the Excel dialog box (open, save, close, cancel) appears twice. When I select "open" (twice) the spreadsheet comes up correctly. When I close the spreadsheet and click on the "Return to Criteria Selection" hyperlink, the spreadsheets generates again. It seems the "Generate Spreadsheet" routine has taken control. (I can return to the previous screen by hitting the BACK button).

Thanks for any help.
I agree. Here's the link:
subject: JSP and Excel
It's not a secret anymore!