模块 excel.io

程序包 com.github.developframework.excel

类 AbstractColumnDefinition<ENTITY,FIELD>

java.lang.Object

com.github.developframework.excel.AbstractColumnDefinition<ENTITY,FIELD>

类型参数:

ENTITY - 实体类型

FIELD - 装填字段类型

所有已实现的接口:

ColumnDefinition<ENTITY>

直接已知子类:

BlankColumnDefinition, FormulaColumnDefinition, GeneralColumnDefinition, LiteralColumnDefinition

public abstract class AbstractColumnDefinition<ENTITY,FIELD>
extends Object
implements ColumnDefinition<ENTITY>

列定义

字段概要

字段

修饰符和类型	字段	说明
protected CellCommentInfo	cellCommentInfo
protected CellStyleKeyProvider<ENTITY>	cellStyleKeyProvider
protected ColumnInfo	columnInfo
protected BiFunction<ENTITY,Object,FIELD>	readConvertFunction
protected BiFunction<ENTITY,FIELD,Object>	writeConvertFunction

构造器概要

构造器

构造器	说明
AbstractColumnDefinition(String field, String header)

方法概要

修饰符和类型	方法	说明
AbstractColumnDefinition<ENTITY,FIELD>	cellStyleKey(CellStyleKeyProvider<ENTITY> cellStyleKeyProvider)
final AbstractColumnDefinition<ENTITY,FIELD>	columnWidth(int columnWidth)	列宽
AbstractColumnDefinition<ENTITY,FIELD>	comment(String author, String commentField, BiFunction<org.apache.poi.ss.usermodel.Drawing,org.apache.poi.ss.usermodel.Cell,org.apache.poi.ss.usermodel.ClientAnchor> anchorFunction)
void	configureCellStyle(org.apache.poi.ss.usermodel.Cell cell, CellStyleManager cellStyleManager, ENTITY entity, Object value)	配置单元格格式
protected String	determineCellStyleKey(org.apache.poi.ss.usermodel.Cell cell, Object value)	根据值决定单元格格式键
Object	getCellValue(org.apache.poi.ss.usermodel.Cell cell, Class<?> fieldClass)	读取单元格值
protected FIELD	getEntityValue(ENTITY entity)	读取实体值
AbstractColumnDefinition<ENTITY,FIELD>	readConvert(BiFunction<ENTITY,Object,FIELD> readConvertFunction)
void	readOutCell(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Cell cell, ENTITY entity)	读取单元格值
protected void	setCellValue(org.apache.poi.ss.usermodel.Cell cell, Object convertValue)	设置单元格值
protected void	setEntityValue(ENTITY entity, Object value)	赋值给实体
AbstractColumnDefinition<ENTITY,FIELD>	writeConvert(BiFunction<ENTITY,FIELD,Object> writeConvertFunction)
Object	writeIntoCell(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Cell cell, ENTITY entity, int index)	值写入单元格

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

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

从接口继承的方法 com.github.developframework.excel.ColumnDefinition

getColumnInfo

字段详细资料

columnInfo

protected ColumnInfo columnInfo

writeConvertFunction

protected BiFunction<ENTITY,FIELD,Object> writeConvertFunction

readConvertFunction

protected BiFunction<ENTITY,Object,FIELD> readConvertFunction

cellStyleKeyProvider

protected CellStyleKeyProvider<ENTITY> cellStyleKeyProvider

cellCommentInfo

protected CellCommentInfo cellCommentInfo

构造器详细资料

AbstractColumnDefinition

public AbstractColumnDefinition(String field,
 String header)

方法详细资料

writeIntoCell

public Object writeIntoCell(org.apache.poi.ss.usermodel.Workbook workbook,
 org.apache.poi.ss.usermodel.Sheet sheet,
 org.apache.poi.ss.usermodel.Cell cell,
 ENTITY entity,
 int index)

值写入单元格

指定者:

writeIntoCell 在接口中 ColumnDefinition<ENTITY>

参数:

workbook - 工作区

cell - 单元格

entity - 实体

index - 实体索引

返回:

字段值

readOutCell

public void readOutCell(org.apache.poi.ss.usermodel.Workbook workbook,
 org.apache.poi.ss.usermodel.Cell cell,
 ENTITY entity)

读取单元格值

指定者:

readOutCell 在接口中 ColumnDefinition<ENTITY>

参数:

workbook - 工作区

cell - 单元格

entity - 实体

setCellValue

protected void setCellValue(org.apache.poi.ss.usermodel.Cell cell,
 Object convertValue)

设置单元格值

参数:

cell - 单元格

convertValue - 转化值

getCellValue

public Object getCellValue(org.apache.poi.ss.usermodel.Cell cell,
 Class<?> fieldClass)

读取单元格值

参数:

cell - 单元格

返回:

单元格值

setEntityValue

protected void setEntityValue(ENTITY entity,
 Object value)

赋值给实体

参数:

entity - 实体

value - 值

getEntityValue

protected FIELD getEntityValue(ENTITY entity)

读取实体值

参数:

entity - 实体

返回:

实体字段值

columnWidth

public final AbstractColumnDefinition<ENTITY,FIELD> columnWidth(int columnWidth)

列宽

参数:

columnWidth - 列宽

configureCellStyle

public void configureCellStyle(org.apache.poi.ss.usermodel.Cell cell,
 CellStyleManager cellStyleManager,
 ENTITY entity,
 Object value)

从接口复制的说明: ColumnDefinition

配置单元格格式

指定者:

configureCellStyle 在接口中 ColumnDefinition<ENTITY>

determineCellStyleKey

protected String determineCellStyleKey(org.apache.poi.ss.usermodel.Cell cell,
 Object value)

根据值决定单元格格式键

writeConvert

public AbstractColumnDefinition<ENTITY,FIELD> writeConvert(BiFunction<ENTITY,FIELD,Object> writeConvertFunction)

readConvert

public AbstractColumnDefinition<ENTITY,FIELD> readConvert(BiFunction<ENTITY,Object,FIELD> readConvertFunction)

cellStyleKey

public AbstractColumnDefinition<ENTITY,FIELD> cellStyleKey(CellStyleKeyProvider<ENTITY> cellStyleKeyProvider)

comment

public AbstractColumnDefinition<ENTITY,FIELD> comment(String author,
 String commentField,
 BiFunction<org.apache.poi.ss.usermodel.Drawing,org.apache.poi.ss.usermodel.Cell,org.apache.poi.ss.usermodel.ClientAnchor> anchorFunction)