Hi i am calling a servlet using JQuery and my servlets create an excel
file at runtime and provides the option for the user to open save or
cancel the file created
JQuery code is
$.post("../reports/BillIDPropIDExcelExport",{csvstring: $
("#vname1").val(),count:$("#vname2").val(),propType:$("#vname3").val
(),instValue:$("#vname4").val()},function(data){
alert(data);document.body.style.cursor="default"; });
and my servlets that creates the file at runtime is
try
{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Customer Details
Connection
Fee");
HSSFDataFormat format = wb.createDataFormat();
HSSFCellStyle cstyle;
cstyle = wb.createCellStyle();
cstyle.setDataFormat(format.getFormat("#,###,###.00"));
HSSFRow row = sheet.createRow((short)0);
HSSFCell c0=row.createCell((short)0);
HSSFCell c1=row.createCell((short)1);
HSSFCell c2=row.createCell((short)2);
c0.setCellValue("CHAR_PREM_ID");
c1.setCellValue("SA_TYPE_CD");
c2.setCellValue("UOM_CD");
c0.setCellStyle(style);
c1.setCellStyle(style);
c2.setCellStyle(style);
String acplotnumber="",finalcsvstring="",finalacplotnumber1="";
String csvstring=request.getParameter("csvstring");
System.out.println(csvstring);
String count=request.getParameter("count");
System.out.println(count);
String instValue1=request.getParameter("instValue");
String propType1=request.getParameter("propType");
if(propType1.length()==4)
propType="'CONBASE','CONGROW'";
else
propType="'"+propType1+"'";
d= new OracleDatabaseConnectionPROD();
connection=d.connect();
//System.out.println("OracleDatabaseConnectionPROD");
stmt = connection.createStatement();
connection.setAutoCommit(false);
{
rs=stmt.executeQuery("SELECT A.CHAR_PREM_ID, SA_TYPE_CD,
F.UOM_CD,
C.BILL_ID, SUM(CALC_AMT) as CALC_AMOUNT from Customers");
while(rs.next())
{
String CHAR_PREM_ID=rs.getString(1);
String SA_TYPE_CD=rs.getString(2);
String UOM_CD=rs.getString(3);
String BILL_ID=rs.getString(4);
float CALC_AMOUNT=rs.getFloat(5);
HSSFCellStyle style1 = wb.createCellStyle();
HSSFFont font1 = wb.createFont();
font1.setFontHeightInPoints((short)8);
style1.setFont(font1);
row = sheet.createRow((short)j);
// bold
HSSFCell cell0 =row.createCell((short)0);
HSSFCell cell1 =row.createCell((short)1);
HSSFCell cell2 =row.createCell((short)2);
cell0.setCellValue(CHAR_PREM_ID);
cell1.setCellValue(SA_TYPE_CD);
cell2.setCellValue(UOM_CD);
cell0.setCellStyle(style1);
cell1.setCellStyle(style1);
j++;
}
//FileOutputStream fileOut = new FileOutputStream(fname
+"ExtractBillID"+dateFormat+".xls");
//wb.write(fileOut);
//fileOut.close();
String filename="ExtractBillID"+dateFormat+".xls";
String contentType =
getServletContext().getMimeType(filename);
System.out.println(contentType);
BufferedInputStream in = null;
try
{
// in = new BufferedInputStream(getServletContext
().getResourceAsStream(fname+filename));
response.setContentType(contentType);
response.setHeader("Content-Disposition"," inline;
filename=" + filename);
ServletOutputStream sout =
response.getOutputStream();
wb.write(sout);
byte[] buffer = new byte[4 * 1024];
// int data;
// while((data = in.read(buffer)) != -1)
// {
// sout.write(buffer, 0, data);
// }
sout.flush();
}
catch(Exception e)
{
e.printStackTrace();
return;
}
finally
{
try
{
// in.close();
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
connection.close();
}
catch(Exception e)
{
//out.println("Error"+e.toString());
e.printStackTrace();
}
}
catch(Exception e)
{
//out.println("Error"+e.toString());
e.printStackTrace();
}
finally
{
//out.println("The Excel File Created Saved At P:\\DATA_LOAD As
ExtractBillID"+dateFormat);
}
}
When i directly access the url i can get the open save an dcancel
option and the servlet runs properly but when i am calling via jquery
the open save and cancel option is not comming can anybody suggest me
how do i do this please
