java web Excel下载导出功能

给页面添加Excel导出功能:

public void setResponse(HttpServletResponse response, HSSFWorkbook workbook, String excelName){
    try {
        if (response != null) {
            response.setContentType("application/vnd.ms-excel;charset=utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=\"" + new String((excelName + 
         ".xls").getBytes("gb2312"), "ISO8859-1")); OutputStream out = response.getOutputStream(); workbook.write(out); out.close(); } }catch (IOException e){ e.printStackTrace(); } }

 

posted @ 2018-07-10 10:11  OnceAgain  阅读(1027)  评论(0)    收藏  举报