Easyexcel 3.1.1版本动态表头样式

雨点打透心脏的1/2处 2024-03-16 23:01 147阅读 0赞

需求：动态生成的表头 **key:value**的形式 List<List>这样的形式。

### 依赖 ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>easyexcel</artifactId>
                <version>3.1.1</version>
                <exclusions>
                    <exclusion>
                        <groupId>javax.servlet</groupId>
                        <artifactId>servlet-api</artifactId>
                    </exclusion>
                    <exclusion>
                        <groupId>org.apache.poi</groupId>
                        <artifactId>poi</artifactId>
                    </exclusion>
                    <exclusion>
                        <groupId>org.apache.poi</groupId>
                        <artifactId>poi-ooxml</artifactId>
                    </exclusion>
                    <exclusion>
                        <groupId>org.apache.poi</groupId>
                        <artifactId>poi-ooxml-schemas</artifactId>
                    </exclusion>
                </exclusions>
    
            </dependency>
    
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml</artifactId>
                <version>4.1.2</version>
            </dependency>

### 数据形式 ###

List<List<String>> dataList=new ArrayList<>();
            List<String> data=new ArrayList<>();
            data.add("项目编号");data.add(info.getProjectCode());
            dataList.add(data);
            List<String> data2=new ArrayList<>();
            data2.add("项目名称");data2.add(info.getProjectName());
            dataList.add(data2);
            List<String> data3=new ArrayList<>();
            data3.add("方案编号");data3.add(StrUtil.isNotEmpty(info.getSchemeCode())?info.getSchemeCode():"");
            dataList.add(data3);
            List<String> data4=new ArrayList<>();
            data4.add("研究分期");data4.add(StrUtil.isNotEmpty(info.getStudyAging())?info.getStudyAging():"");
            dataList.add(data4);
            List<String> data5=new ArrayList<>();
            data5.add("研究产品");data5.add(StrUtil.isNotEmpty(info.getStudyProduct())?info.getStudyProduct():"");
            dataList.add(data5);
            List<String> data6=new ArrayList<>();
            data6.add("项目经理");data6.add(StrUtil.isNotEmpty(info.getMainPM())?info.getMainPM():"");
            dataList.add(data6);

### 主要代码； ###

正常导出即可；添加一个样式注册器；

public class DynamicHeadHorizontalCellStyleStrategy  extends AbstractVerticalCellStyleStrategy  {
        
    
    
    
    
        @Override
        protected WriteCellStyle contentCellStyle(CellWriteHandlerContext context) {
        
         // 因为我这里只在第一列添加 样式 所以我判断是否第一列
            Integer columnIndex = context.getColumnIndex();
           
            // 获取样式实例
            WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
    
            // 设置字体
            WriteFont contentWriteFont = new WriteFont();
            if(columnIndex==0){
         
                contentWriteFont.setColor(IndexedColors.WHITE1.getIndex());
            }
            contentWriteFont.setFontHeightInPoints((short) 12);//设置字体大小
            contentWriteFont.setFontName("宋体"); //设置字体名字
            contentWriteCellStyle.setWriteFont(contentWriteFont);//在样式用应用设置的字体;
            //设置样式;
            contentWriteCellStyle.setBorderBottom(BorderStyle.THIN);//设置底边框;
            contentWriteCellStyle.setBottomBorderColor((short) 0);//设置底边框颜色;
            contentWriteCellStyle.setBorderLeft(BorderStyle.THIN);  //设置左边框;
            contentWriteCellStyle.setLeftBorderColor((short) 0);//设置左边框颜色;
            contentWriteCellStyle.setBorderRight(BorderStyle.THIN);//设置右边框;
            contentWriteCellStyle.setRightBorderColor((short) 0);//设置右边框颜色;
            contentWriteCellStyle.setBorderTop(BorderStyle.THIN);//设置顶边框;
            contentWriteCellStyle.setTopBorderColor((short) 0); ///设置顶边框颜色;
    
            contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);// 水平居中
            contentWriteCellStyle.setWrapped(true); //设置自动换行;
            contentWriteCellStyle.setShrinkToFit(true);//设置文本收缩至合适
            if(columnIndex==0){
        
                contentWriteCellStyle.setFillForegroundColor(IndexedColors.BLUE_GREY.getIndex());
              //  contentWriteCellStyle.setFillBackgroundColor(IndexedColors.BLUE_GREY.getIndex());
                contentWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
            }
            return contentWriteCellStyle;
        }
    
    }

导出结果；  
![在这里插入图片描述][2bb79a19ab774d7da0a920031d557de8.png]

[2bb79a19ab774d7da0a920031d557de8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/5404bb010e0d4b868361d58d222059d2.png