aspose file tools*
The moose likes Servlets and the fly likes problem in headers and content types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "problem in headers and content types" Watch "problem in headers and content types" New topic
Author

problem in headers and content types

vijayz devraj
Greenhorn

Joined: Apr 03, 2008
Posts: 7
my web application aim is to download the data from mysql to excel sheet . but using internet explorer browser if iam downloading the data to excel sheet iam able to download the empty excel sheet ie,, iam not able to see the data.
but the same application if iam using mozilla firefox browser iam able to download the excel sheet with data.
i want to download the data by using both browsers.

iam displaying the headers and content types

response.reset();
byte[] blobdata1 = wb1.getBytes();
response.setContentType("application/vnd.ms-excel: xls, xlb: Microsoft Excel Document");
response.setHeader("Content-Disposition", "inline; filename="+" Excel123"+".xls");
response.setDateHeader("max-age", 0);
response.setHeader("cache-control", "no-cache");
response.setHeader("Content-Encoding", "en-US");
response.setHeader("Connection", "keep-alive");
response.setHeader("Expires", "0");
response.setHeader("Pragma", "no-cache");
OutputStream out = response.getOutputStream();
int off = 0;
int l = (int) wb1.getBytes().length;
out.write(blobdata1, off, l);
out.flush();
out.close();

Needed suggestions
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60071
    
  65

Please be sure to use UBB code tags when posting code to the forums. Unformatted code is extermely hard to read and many people that might be able to help you will just move along. Please read this for more information.

You can go back and change your post to add code tags by clicking the .


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Anirvan Majumdar
Ranch Hand

Joined: Feb 22, 2005
Posts: 261
Ain't too sure, but you could try setting the following for the Content-type header and see if it works:

application/msexcel
application/x-msexcel
application/ms-excel

Browsers have a weird way of being touchy about what one sets for the Content-type header.
Also as I see, you haven't set the Content-length header. Set it to the value of blobdata1.length
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in headers and content types
 
Similar Threads
download problem
problem with download manager in IE browser.
problem with download manager in IE browser.
problem when downloading excel sheet from struts application using Internet explorer
convert excel