Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript 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...
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!