Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

problem when downloading excel sheet from struts application using Internet explorer  RSS feed

vijayz devraj
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
byte[] blobdata1 = wb1.getBytes();
response.setContentType("application/ 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);

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
Boost this thread!