Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem when downloading excel sheet from struts application using Internet explorer

 
vijayz devraj
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My struts application aim is to download data from mysql to excel sheet. the problem is,,, whenever iam downlaoding a excel file from struts application using internet explorer browser iam able to download the excel sheet but the data is not displayed.
but if i use mozilla firefox and download the excel sheet i can view the data also..

my code to download the excel sheet is
}
response.reset();
byte[] blobdata1 = wb1.getBytes();
response.setContentType("application/vnd.ms-excel: xls, xlb: Microsoft Excel Document");
response.setHeader("Content-Disposition", "inline; filename=" + title+".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();
}

please let me know what changes i need to do so that ican downlaod and view the data in excel sheet by using internet explorer...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic