poi导出.xls格式excel

最新推荐文章于 2023-07-11 10:48:45 发布

肩上责任

最新推荐文章于 2023-07-11 10:48:45 发布

阅读量333

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/qq_33159561/article/details/65443162

版权

java 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

public void reportMergeXls(List<SysOffice> list, Model model, HttpServletResponse response,
            HttpServletRequest request) throws Exception {
        String basepath = request.getServletContext().getRealPath("/");
        String webapps = basepath.substring(0, basepath.lastIndexOf("webapps") - 1) + "/webapps";
        String path = webapps + request.getContextPath() + "/static/template/已认领单位统计信息导出模板.xlsx";
        HSSFWorkbook work = new HSSFWorkbook(new FileInputStream(path));
        try {
            HSSFSheet sheet = work.getSheetAt(0);
            for (int i = 0; i < list.size(); i++) {
                sheet.getRow(3 + i).getCell(0).setCellValue(i + 1);     //序号
                sheet.getRow(3 + i).getCell(1).setCellValue(list.get(i).getName()); 
            }
            //下载xls文件
            response.setContentType("application/msexcel");
            String xlsFileName = "已认领单位统计信息" + DateUtils.getDate("yyyyMMddHHmmss") + ".xlsx";
            response.setHeader("Content-disposition",
                    "attachment;filename=" + new String(xlsFileName.getBytes("utf-8"), "iso-8859-1"));
            response.setCharacterEncoding("utf-8");
            OutputStream fos = response.getOutputStream(); 
            work.write(fos);
            fos.close();
        } catch (Exception e) {
            System.out.println("文件输出失败!");
            e.printStackTrace();
        }
    }