xin.allonsy.utils

类 ExcelTemplateCellStyleStrategy

java.lang.Object

com.alibaba.excel.write.style.AbstractCellStyleStrategy

xin.allonsy.utils.ExcelTemplateCellStyleStrategy

所有已实现的接口:

com.alibaba.excel.event.Handler, com.alibaba.excel.event.NotRepeatExecutor, com.alibaba.excel.write.handler.CellWriteHandler, com.alibaba.excel.write.handler.SheetWriteHandler, com.alibaba.excel.write.handler.WriteHandler

public class ExcelTemplateCellStyleStrategy
extends com.alibaba.excel.write.style.AbstractCellStyleStrategy

excel样式策略

字段概要

字段

限定符和类型	字段和说明
private Map<Integer,org.apache.poi.ss.usermodel.CellStyle>	colSpecialCellStyleMap
private Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle>	colSpecialWriteCellStyleMap 特殊列样式
private org.apache.poi.ss.usermodel.CellStyle	defaultContentCellStyle
private com.alibaba.excel.write.metadata.style.WriteCellStyle	defaultContentWriteCellStyle 默认正文样式
private org.apache.poi.ss.usermodel.CellStyle	defaultHeadCellStyle 转换为CellStyle类型
private com.alibaba.excel.write.metadata.style.WriteCellStyle	defaultHeadWriteCellStyle 默认表头样式
private Map<Integer,org.apache.poi.ss.usermodel.CellStyle>	rowSpecialCellStyleMap
private Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle>	rowSpecialWriteCellStyleMap 特殊行样式

构造器概要

构造器

构造器和说明
ExcelTemplateCellStyleStrategy(com.alibaba.excel.write.metadata.style.WriteCellStyle defaultHeadWriteCellStyle, com.alibaba.excel.write.metadata.style.WriteCellStyle defaultContentWriteCellStyle, Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle> rowSpecialWriteCellStyleMap, Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle> colSpecialWriteCellStyleMap)

方法概要

限定符和类型	方法和说明
protected void	initCellStyle(org.apache.poi.ss.usermodel.Workbook workbook)
protected void	setContentCellStyle(org.apache.poi.ss.usermodel.Cell cell, com.alibaba.excel.metadata.Head head, Integer integer)
protected void	setHeadCellStyle(org.apache.poi.ss.usermodel.Cell cell, com.alibaba.excel.metadata.Head head, Integer integer)

从类继承的方法 com.alibaba.excel.write.style.AbstractCellStyleStrategy

afterCellCreate, afterCellDispose, afterSheetCreate, beforeCellCreate, beforeSheetCreate, uniqueValue

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

字段详细资料

defaultHeadWriteCellStyle

private com.alibaba.excel.write.metadata.style.WriteCellStyle defaultHeadWriteCellStyle

默认表头样式

defaultContentWriteCellStyle

private com.alibaba.excel.write.metadata.style.WriteCellStyle defaultContentWriteCellStyle

默认正文样式

rowSpecialWriteCellStyleMap

private Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle> rowSpecialWriteCellStyleMap

特殊行样式

colSpecialWriteCellStyleMap

private Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle> colSpecialWriteCellStyleMap

特殊列样式

defaultHeadCellStyle

private org.apache.poi.ss.usermodel.CellStyle defaultHeadCellStyle

转换为CellStyle类型

defaultContentCellStyle

private org.apache.poi.ss.usermodel.CellStyle defaultContentCellStyle

rowSpecialCellStyleMap

private Map<Integer,org.apache.poi.ss.usermodel.CellStyle> rowSpecialCellStyleMap

colSpecialCellStyleMap

private Map<Integer,org.apache.poi.ss.usermodel.CellStyle> colSpecialCellStyleMap

构造器详细资料

ExcelTemplateCellStyleStrategy

public ExcelTemplateCellStyleStrategy(com.alibaba.excel.write.metadata.style.WriteCellStyle defaultHeadWriteCellStyle,
                                      com.alibaba.excel.write.metadata.style.WriteCellStyle defaultContentWriteCellStyle,
                                      Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle> rowSpecialWriteCellStyleMap,
                                      Map<Integer,com.alibaba.excel.write.metadata.style.WriteCellStyle> colSpecialWriteCellStyleMap)

方法详细资料

initCellStyle

protected void initCellStyle(org.apache.poi.ss.usermodel.Workbook workbook)

指定者:

initCellStyle 在类中 com.alibaba.excel.write.style.AbstractCellStyleStrategy

setHeadCellStyle

protected void setHeadCellStyle(org.apache.poi.ss.usermodel.Cell cell,
                                com.alibaba.excel.metadata.Head head,
                                Integer integer)

指定者:

setHeadCellStyle 在类中 com.alibaba.excel.write.style.AbstractCellStyleStrategy

setContentCellStyle

protected void setContentCellStyle(org.apache.poi.ss.usermodel.Cell cell,
                                   com.alibaba.excel.metadata.Head head,
                                   Integer integer)

指定者:

setContentCellStyle 在类中 com.alibaba.excel.write.style.AbstractCellStyleStrategy