wood burning stoves 2.0*
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: 41839
    
  63
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Opening Excel with JSP