excel导出+提示用户下载
来源:互联网 发布:js中的insertArray 编辑:程序博客网 时间:2024/05/20 06:28
/** * @author yzh 导出excel报表 * @return * @throws Exception */ public String exportCollectExcel() throws Exception { this.checkYM();//检查年月的方法,略 Common c = new Common();//日期处理方法,略 Company company = this.unitService.findCompanyById(companyid); // String filename = year + "年" + month + "月份合同及收款汇总表"; String filename = "合同额及收款情况_" + company.getNameshort() + "_" + year + "年" + month + "月_" + c.getStrDate(); filename = new String(filename.getBytes(), "iso8859-1");//乱码处理 HttpServletResponse response = ServletActionContext.getResponse(); OutputStream os = response.getOutputStream();// 取得输出流 response.reset();// 清空输出流 response.setContentType("application/xls;charset=UTF-8");// 定义输出类型 response.setHeader("Content-disposition", "attachment; filename=" + filename + ".xls");// 设定输出文件头 WritableWorkbook wbook = collectService.exportCollectExcel( this.companyid, this.year, this.month, os);//取得excel 对象方法,略 wbook.write(); // 写入文件 response.flushBuffer();// 刷新 wbook.close(); os.close(); return null; }