程序包 com.sie.mbm.mom.framework.excel.handler

类 SampleWriteHandler

java.lang.Object

com.sie.mbm.mom.framework.excel.handler.SampleWriteHandler

所有已实现的接口:

com.alibaba.excel.event.Handler, com.alibaba.excel.event.Order, com.alibaba.excel.write.handler.SheetWriteHandler, com.alibaba.excel.write.handler.WriteHandler

public class SampleWriteHandler
extends Object
implements com.alibaba.excel.write.handler.SheetWriteHandler

字段概要

字段

修饰符和类型	字段	说明
private final Map<Integer,String[]>	columnDropdownMap
private int	currentRow
private String	HIDDEN_SHEET_NAME
private static final org.slf4j.Logger	logger

构造器概要

构造器

构造器	说明
SampleWriteHandler(Map<Integer,String[]> columnDropdownMap)
SampleWriteHandler(Map<Integer,String[]> columnDropdownMap, String sheetName)

方法概要

修饰符和类型	方法	说明
void	afterSheetCreate(com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder writeWorkbookHolder, com.alibaba.excel.write.metadata.holder.WriteSheetHolder writeSheetHolder)
private org.apache.poi.ss.usermodel.Sheet	createHiddenSheet(org.apache.poi.ss.usermodel.Workbook workbook)	创建新的隐藏Sheet（每次生成模板时新建，避免行重复）
private String	toColumnName(int index)	数字列索引转Excel列名（0 -> A, 1 -> B）
private String	writeOptionsToHiddenSheet(org.apache.poi.ss.usermodel.Sheet hiddenSheet, int columnIndex, String[] options)	将下拉数据写入隐藏Sheet，并返回引用公式

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

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

从接口继承的方法 com.alibaba.excel.event.Handler

order

从接口继承的方法 com.alibaba.excel.write.handler.SheetWriteHandler

afterSheetCreate, beforeSheetCreate, beforeSheetCreate

字段详细资料

logger

private static final org.slf4j.Logger logger

HIDDEN_SHEET_NAME

private String HIDDEN_SHEET_NAME

columnDropdownMap

private final Map<Integer,String[]> columnDropdownMap

currentRow

private int currentRow

构造器详细资料

SampleWriteHandler

public SampleWriteHandler(Map<Integer,String[]> columnDropdownMap)

SampleWriteHandler

public SampleWriteHandler(Map<Integer,String[]> columnDropdownMap,
 String sheetName)

方法详细资料

afterSheetCreate

public void afterSheetCreate(com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder writeWorkbookHolder,
 com.alibaba.excel.write.metadata.holder.WriteSheetHolder writeSheetHolder)

指定者:

afterSheetCreate 在接口中 com.alibaba.excel.write.handler.SheetWriteHandler

createHiddenSheet

private org.apache.poi.ss.usermodel.Sheet createHiddenSheet(org.apache.poi.ss.usermodel.Workbook workbook)

创建新的隐藏Sheet（每次生成模板时新建，避免行重复）

writeOptionsToHiddenSheet

private String writeOptionsToHiddenSheet(org.apache.poi.ss.usermodel.Sheet hiddenSheet,
 int columnIndex,
 String[] options)

将下拉数据写入隐藏Sheet，并返回引用公式

toColumnName

private String toColumnName(int index)

数字列索引转Excel列名（0 -> A, 1 -> B）