File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Opening Excel with JSP

 
Jetendra Ivaturi
Ranch Hand
Posts: 159
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jetendra Ivaturi
Ranch Hand
Posts: 159
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic