easyexcel怎么设置表头宽度_easyexcel自适应列宽

在导出时注册registerWriteHandler(new CustomCellWriteHandler())

/**

* @author jamin

* @date 2020/7/29 11:28

* 设置自适应列宽

*/

public class CustomCellWriteHandler extends AbstractColumnWidthStyleStrategy {

private Map> CACHE = new HashMap<>();

@Override

protected void setColumnWidth(WriteSheetHolder writeSheetHolder, List cellDataList, Cell cell, Head head, Integer integer, Boolean isHead) {

boolean needSetWidth = isHead || !CollectionUtils.isEmpty(cellDataList);

if (needSetWidth) {

Map maxColumnWidthMap = CACHE.get(writeSheetHolder.getSheetNo());

if (maxColumnWidthMap == null) {

maxColumnWidthMap = new HashMap<>();

CACHE.put(writeSheetHolder.getSheetNo(), maxColumnWidthMap);

}

Integer columnWidth = this.dataLength(cellDataList,