EasyExcel設定動态表頭的時候,動态設定字型顔色不生效的問題
需求:是動态的設定excel表頭,并且請求體的内容需要使用字型标紅
官方沒有例子,并且因為是動态表頭,是以在初始化ExcelWriterBuilder的時候,沒有辦法直接注冊為pojo類繼而使用@ContentStyle注解來處理字型樣式,使用了網上大多數的例子,但是都無法達到我的需求。
官方連結:
https://easyexcel.opensource.alibaba.com
1.首先嘗試使用了registerWriteHandler方法,但是并不生效
EasyExcel.write(fileName).registerWriteHandler(new CellWriteHandler(){
//并實作了所有内部方法
})
2.查查源碼看源碼裡面設定的是如何生效的。
①在com.alibaba.excel.util.ClassUtils裡讀取了Class上标注的資訊,之後和ExcelContentProperty産生了聯系
②在com.alibaba.excel.util.ClassUtils-184L看見了,向ExcelContentProperty中設定了contentFontProperty屬性
③查詢contentFontProperty屬性的方法的過程中,在com.alibaba.excel.write.metadata.holder.AbstractWriteHolder中的dealStyle中擷取了getContentFontProperty屬性
④通過看上下文,是new了一個com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy抽象類,然後放入了一個list中。
⑤通過官方API中可以發現**EasyExcel.write(fileName).registerWriteHandler(WriteHandler writehandler)**中,注冊handler的時候是一個list中。
⑥初始化字型的時候使用了AbstractVerticalCellStyleStrategy抽象類,我們也使用試一下,試一下之後就成功了。
直接看答案
效果
代碼
項目位址:https://gitee.com/wangyiSelf/LearnToGrow/tree/master/%E6%BA%90%E7%A0%81/EasyExcelSetDynamicHeaderAndContentFont
maven倉庫
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13.2</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>3.1.0</version>
</dependency>
<dependency>
<groupId>com.google.guava</groupId>
<artifactId>guava</artifactId>
<version>31.1-jre</version>
</dependency>
</dependencies>
靜态代碼
package com.wangyi.excel;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.google.common.collect.ImmutableList;
import com.wangyi.excel.handler.ExampleDataRedColorHandler;
import org.junit.Test;
import java.io.File;
import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;
import java.util.List;
/**
* 通過EasyExcel生成動态表頭和設定紅色字型
*/
public class EasyExcelSetDynamicHeaderAndContentFont {
@Test
public void generateExcelAndSetDynamicHeaderAndContentFont() throws UnsupportedEncodingException {
String path = EasyExcelSetDynamicHeaderAndContentFont.class.getProtectionDomain().getCodeSource().getLocation().getPath();
String parentPath = new File(path).getParent();
parentPath = URLDecoder.decode(parentPath, "utf-8");
ExcelWriter excelWriter = EasyExcel.write(parentPath + "/DynamicHeaderContentFont" + System.currentTimeMillis() + ".xlsx").registerWriteHandler(new ExampleDataRedColorHandler()).build();
List<String> column1 = ImmutableList.of("表頭1");
List<String> column2 = ImmutableList.of("表頭2");
ImmutableList<List<String>> head = ImmutableList.of(column1, column2);
WriteSheet writeSheet = EasyExcel.writerSheet(0, "模闆").head(head).build();
List<String> value1 = ImmutableList.of("表頭1","表頭1");
List<String> value2 = ImmutableList.of("表頭2","表頭2");
List<List<String>> writeData = ImmutableList.of(value1, value2);
excelWriter.write(writeData, writeSheet);
excelWriter.finish();
}
}
package com.wangyi.excel.handler;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.alibaba.excel.metadata.property.FontProperty;
import com.alibaba.excel.write.handler.context.CellWriteHandlerContext;
import com.alibaba.excel.write.metadata.style.WriteCellStyle;
import com.alibaba.excel.write.style.AbstractVerticalCellStyleStrategy;
import org.apache.poi.ss.usermodel.IndexedColors;
/**
* 示例資料紅色标記實作類
*/
public class ExampleDataRedColorHandler extends AbstractVerticalCellStyleStrategy {
@Override
protected WriteCellStyle contentCellStyle(CellWriteHandlerContext context) {
ExcelContentProperty excelContentProperty = context.getExcelContentProperty();
FontProperty contentFontProperty = excelContentProperty.getContentFontProperty();
if (contentFontProperty == null) {
contentFontProperty = new FontProperty();
}
contentFontProperty.setColor(IndexedColors.RED.getIndex());
return WriteCellStyle.build(excelContentProperty.getContentStyleProperty(),
contentFontProperty);
}
}