生成 excel 下载

abstract protected void fillWorkbook(WritableWorkbook wwb, ActionFormBean formBean, HttpServletRequest request);

protected void sendExcelFile(String excelFileName, HttpServletRequest request, HttpServletResponse response, ActionFormBean formBean) {
try {
response.setContentType("application/vnd.ms-excel");
response.setContentType("application/octed-stream");
response.setHeader("Content-Disposition","attachment;filename=" + CharsetUtil.ChineseToUnicode(excelFileName));

Workbook wb = Workbook.getWorkbook(getServlet().getServletContext().getResource("/WEB-INF/excelTemplate/" +　excelFileName));
WritableWorkbook wwb = Workbook.createWorkbook(response.getOutputStream(), wb);
fillWorkbook(wwb,formBean,request);
wwb.write();
wb.close();
wwb.close();
} catch(Exception e) {
//todo:log
}
}