EasyExcel 设置边框样式（线条类型和线条颜色）

最新推荐文章于 2024-08-13 16:02:17 发布

旭东怪

最新推荐文章于 2024-08-13 16:02:17 发布

阅读量1.8w

点赞数 1

分类专栏：文档处理工具文章标签： java poi easyexcel

本文链接：https://blog.csdn.net/qq_38974638/article/details/117453000

版权

文档处理工具专栏收录该内容

103 篇文章 23 订阅

订阅专栏

1 Maven配置

        <!--hutool工具包-->
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.5.1</version>
        </dependency>
        <!-- EasyExcel文档处理工具 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.8</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>

2 调试代码

    /**
     * 导出（设置边框样式（线条类型和线条颜色））
     *
     * @param response
     */
    @GetMapping("/exportBorderStyle")
    public void exportBorderStyle(HttpServletResponse response) {
        try {
            //生成表格数据
            List<List<Object>> dataList = new ArrayList<>();
            dataList.add(new ArrayList<>(Arrays.asList(new Object[]{"表头11", "表头2", "表头3", "表头4"})));
            dataList.add(new ArrayList<>(Arrays.asList(new Object[]{"表头17777777777", "表头2", "表头3", "表头4444"})));
            dataList.add(new ArrayList<>(Arrays.asList(new Object[]{"表头31", "表头2", "表头3", "表头4"})));
            //导出文件
            String fileName = new String("文件名称.xlsx".getBytes(), "UTF-8");

            List<CellStyleModel> cellStyleList = new ArrayList<>();
            //第一种方式四条边框一起设置线条类型和边框颜色
            //设置单元格边框类型和边框颜色
            cellStyleList.add(CellStyleModel.createBorderCellStyleModel("模板", 0, 0, BorderStyle.DOUBLE, IndexedColors.RED));

            //第二种方式四条边框分开设置线条类型和边框颜色
            //设置单元格边框类型和边框颜色
            cellStyleList.add(CellStyleModel.createBorderCellStyleModel("模板", 0, 1, BorderStyle.DOUBLE, BorderStyle.DOUBLE
                    , BorderStyle.DOUBLE, BorderStyle.DOUBLE, IndexedColors.RED, IndexedColors.RED, IndexedColors.RED, IndexedColors.RED));

            //第三种方式四条边框单独设置线条类型和边框颜色
            cellStyleList.add(CellStyleModel.createTopBorderLineTypeCellStyleModel("模板", 1, 2, BorderStyle.THIN));
            cellStyleList.add(CellStyleModel.createRightBorderLineTypeCellStyleModel("模板", 1, 0, BorderStyle.DOUBLE));
            cellStyleList.add(CellStyleModel.createBottomBorderLineTypeCellStyleModel("模板", 1, 0, BorderStyle.DOTTED));
            cellStyleList.add(CellStyleModel.createLeftBorderLineTypeCellStyleModel("模板", 1, 2, BorderStyle.MEDIUM));
            cellStyleList.add(CellStyleModel.createTopBorderColorCellStyleModel("模板", 1, 2, IndexedColors.BLUE));
            cellStyleList.add(CellStyleModel.createRightBorderColorCellStyleModel("模板", 1, 0, IndexedColors.BLUE));
            cellStyleList.add(CellStyleModel.createBottomBorderColorCellStyleModel("模板", 1, 0, IndexedColors.BLUE));
            cellStyleList.add(CellStyleModel.createLeftBorderColorCellStyleModel("模板", 1, 2, IndexedColors.BLUE));

            response.addHeader("Content-Disposition", "filename=" + fileName);
            //设置类型，扩展名为.xls
            response.setContentType("application/vnd.ms-excel");
            ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new CustomCellStyleHandler(cellStyleList)).build();
            WriteSheet writeSheet = EasyExcel.writerSheet("模板").build();
            excelWriter.write(dataList, writeSheet);
            //千万别忘记finish 会帮忙关闭流
            excelWriter.finish();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }