Downloading Excel file in jsp

[Ganeshkumar cheekati]

Hi
I am trying to download excel file and this is my jsp code

<%@page  contentType="text/html;charset=UTF-8" language="java"%>
<%@ page pageEncoding="UTF-8" %>
<%@ taglib uri="/struts-tags" prefix="struts"%>
<%@ page import="java.io.*"%>
<%
 String sFile = (String) request.getAttribute("sFilePath");
System.out.println("sfilepath in jsp file is........."+sFile);
 String mimeType = getMimeType(sFile);
 System.out.println(mimeType);
 //response.setContentType(mimeType);
 //response.setHeader("Content-Disposition", "inline;filename=\"" + sFile + "\"");
 response.setContentType(mimeType);
 response.setHeader("Content-disposition","attachment;filename=\""+sFile+"\"");
 

 FileInputStream in = null;
 OutputStream output=null;
			try {
				output = response.getOutputStream();
				in = new FileInputStream(sFile);
				byte[] buffer = new byte[5 * 1024];
				int size = 0;
				while ((size = in.read(buffer, 0, buffer.length)) > 0) {
					output.write(buffer, 0, size);
				}
				
						
			} catch (Exception e) {
			} 
			
			
			finally {
				in.close();		
				output.flush(); 
				output.close();
			}
			if (true)
				return;
			 

%>
<%!
static String getMimeType (String fName) {
		fName = fName.toLowerCase();
		if (fName.endsWith(".jpg") || fName.endsWith(".jpeg") || fName.endsWith(".jpe")) return "image/jpeg";
		else if (fName.endsWith(".gif")) return "image/gif";
		else if (fName.endsWith(".pdf")) return "application/pdf";
		else if (fName.endsWith(".htm") || fName.endsWith(".html") || fName.endsWith(".shtml")) return "text/html";
		else if (fName.endsWith(".avi")) return "video/x-msvideo";
		else if (fName.endsWith(".mov") || fName.endsWith(".qt")) return "video/quicktime";
		else if (fName.endsWith(".mpg") || fName.endsWith(".mpeg") || fName.endsWith(".mpe")) return "video/mpeg";
		else if (fName.endsWith(".zip")) return "application/zip";
		else if (fName.endsWith(".tiff") || fName.endsWith(".tif"))  return "image/tif";
		else if (fName.endsWith(".rtf")) return "application/rtf";
		else if (fName.endsWith(".mid") || fName.endsWith(".midi")) return "audio/x-midi";
		else if (fName.endsWith(".xl") || fName.endsWith(".xls") || fName.endsWith(".xlv")
				|| fName.endsWith(".xla") || fName.endsWith(".xlb") || fName.endsWith(".xlt")
				|| fName.endsWith(".xlm") || fName.endsWith(".xlk")) return "application/vnd.ms-excel";
		else if (fName.endsWith(".doc") || fName.endsWith(".doc")) return "application/msword";
		else if (fName.endsWith(".png")) return "image/png";
		else if (fName.endsWith(".xml")) return "text/xml";
		else if (fName.endsWith(".svg")) return "image/svg+xml";
		else if (fName.endsWith(".mp3")) return "audio/mp3";
		else if (fName.endsWith(".ogg")) return "audio/ogg";
		else return "text/plain";
	}
%>
    

javascript code to open new window..

   function callExcel(p1,p2)
{
	
	TMWin=window.open("","Open_File","resizable=yes,scrollbars=yes,toolbar=no,location=no,menubar=yes,status=yes,directories=yes,width=500,height=500");
	TMWin.document.write("Contacting Server...");
	TMWin.document.write("<FORM name='child_window'  method=post>");
	TMWin.document.write("<input type='hidden' name=n1value=''/>");
	TMWin.document.write("<input type='hidden' name=n2value=''/>");
	TMWin.document.write("</form>");
	TMWin.document.child_window.n1.value=p1;
	TMWin.document.child_window.n2.value=p2;
	
	TMWin.document.child_window.action="../.../.......action";
	TMWin.document.child_window.submit();
	
} 

its acting differently in different versions of IE..
IN IE6 excel sheet is opening in new window which i provided in javascript...

but in ie8 excel sheet is opening in normal sheet format istead of opening in new window using javascript..

Can anyone give me solution ?

Thanks in advance...

[Devaka Cooray]

If your question had something to do with Java, I'd say that first you should move all these Java codes away from your JSP, as the purpose of a JSP is only to provide the output as a viewer component - it shouldn't have any business logic to be done with pure Java code.
For now, this question looks like more related to JavaScript - moving this to HTML/JavaScript forum.