• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

forward problem after create excel file

 
Eva Tang
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a servlet that create an excel file, I want it to forward to another url if the user chose to save the excel file. How now after saving the file it shouldn't foward. can anyone help?
Thanks.
public class DBHandler extends HttpServlet
{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
FormBean f = (FormBean) request.getAttribute("formHandler");
try {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "filename=" + f.getliner() + f.getmonth()
+ f.getyear() + ".xls");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");
sheet.setMargin(HSSFSheet.BottomMargin, 0.5);
sheet.setMargin(HSSFSheet.LeftMargin, 0.5);
sheet.setMargin(HSSFSheet.RightMargin, 0.5);
sheet.setMargin(HSSFSheet.TopMargin, 0.5);
HSSFDataFormat format = wb.createDataFormat();
HSSFPrintSetup ps = sheet.getPrintSetup();
ps.setScale((short) 80);
ps.setLandscape(true);
ps.setFooterMargin(0.25);
ps.setHeaderMargin(0.25);
...........
// Write the output
OutputStream out = response.getOutputStream();
wb.write(out);
out.close();
getServletConfig().getServletContext().getRequestDispatcher("/jsp/dem/dem_display.jsp").forward(request, response);
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic