posted 16 years ago
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