Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes BEA/Weblogic and the fly likes Opening Excel with JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Opening Excel with JSP" Watch "Opening Excel with JSP" New topic
Author

Opening Excel with JSP

Jetendra Ivaturi
Ranch Hand

Joined: Feb 08, 2007
Posts: 159
Hi Every body...

I am trying to open an excel sheet from a jsp page using setContentType();

Its opening but its giving garble data... I have also tried using <mime-mapping>, with no luck.

Am using wls 8. could any one suggest an option for this.

Thanks.


SCJP 1.4 & 1.5, SCWCD 1.5. Learn and Let Learn.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41106
    
  45
What do you mean by "open"? Are you streaming an XLS file to the client? If so, that won't work. JSPs are for text, not for binary content; you need to use a servlet instead. If you're trying to do something else, please describe it in more detail.


Ping & DNS - my free Android networking tools app
Jetendra Ivaturi
Ranch Hand

Joined: Feb 08, 2007
Posts: 159
I have to download the excel sheet. I mean to say am using setContentType(application/vs.ms-excel).

However its working fine in tomcat. Am able to download the excel sheet.

Where as in weblogic it wasn't possible.

My doubt is with content type.

So have use reset() method of response object. Its working fine.

Thanks for your time.

Ulf Dittmer... Is that the right behaviour what am doing?

Kindly suggest, Thanks once again.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Opening Excel with JSP
 
Similar Threads
Export data from Jsp to Excel taking more load time
A simple web-app to retrieve and display an Excel Sheet
excel page not opening in a browser
Close Popup and refresh parent
problem while Opening Excel and pdfs in JSP using Websphere Application Server 6.1