Hutool导出Excel

荭色海湾

于 2024-11-16 16:37:19 发布

阅读量158

点赞数 5

CC 4.0 BY-SA版权

分类专栏： SpringBoot 文章标签： excel windows

本文链接：https://blog.youkuaiyun.com/qq_53374893/article/details/143819399

SpringBoot 专栏收录该内容

90 篇文章 ¥19.90 ¥99.00

订阅专栏

超级会员免费看

   @Override
    public void exportNbCardVo(List<NbCardVo> nbCardVoList, HttpServletResponse response) throws CodeException {
        BigExcelWriter bigExcelWriter = null;
        try {
            String  fileName = URLEncoder.encode("nb卡批量导出.xlsx", StandardCharsets.UTF_8.toString());
            response.addHeader("Content-Disposition", "attachment;filename=" + fileName);
            bigExcelWriter = new BigExcelWriter(nbCardVoList.size()+1);

            List<List<String>> rows = new ArrayList<>();
            List<String> title = CollUtil.newArrayList(
                    "序号",
                    "电话卡号",
               
                    "项目名称",
                    "创建时间");
            rows.add(title);

            Strin