程序包 com.sh.wf.excel.write.builder

类 ExcelWriterSheetBuilder

java.lang.Object

com.sh.wf.excel.write.builder.ExcelWriterSheetBuilder

public class ExcelWriterSheetBuilder
extends Object

Build sheet

构造器概要

构造器

构造器	说明
ExcelWriterSheetBuilder()
ExcelWriterSheetBuilder(ExcelWriter excelWriter)

方法概要

修饰符和类型	方法	说明
ExcelWriterSheetBuilder	automaticMergeHead(Boolean automaticMergeHead)	Whether to automatically merge headers.Default is true.
WriteSheet	build()
void	doFill(Object data)
void	doFill(Object data, FillConfig fillConfig)
void	doWrite(List data)
ExcelWriterSheetBuilder	excludeColumnFiledNames(Collection<String> excludeColumnFiledNames)	Ignore the custom columns.
ExcelWriterSheetBuilder	excludeColumnIndexes(Collection<Integer> excludeColumnIndexes)	Ignore the custom columns.
ExcelWriterSheetBuilder	head(Class clazz)	You can only choose one of the head(List) and head(Class)
ExcelWriterSheetBuilder	head(List<List<String>> head)	You can only choose one of the head(List) and head(Class)
ExcelWriterSheetBuilder	includeColumnFiledNames(Collection<String> includeColumnFiledNames)	Only output the custom columns.
ExcelWriterSheetBuilder	includeColumnIndexes(Collection<Integer> includeColumnIndexes)	Only output the custom columns.
ExcelWriterSheetBuilder	needHead(Boolean needHead)
ExcelWriterSheetBuilder	registerConverter(Converter converter)	Custom type conversions override the default.
ExcelWriterSheetBuilder	registerWriteHandler(WriteHandler writeHandler)	Custom write handler
ExcelWriterSheetBuilder	relativeHeadRowIndex(Integer relativeHeadRowIndex)	Writes the head relative to the existing contents of the sheet.
ExcelWriterSheetBuilder	sheetName(String sheetName)	sheet name
ExcelWriterSheetBuilder	sheetNo(Integer sheetNo)	Starting from 0
ExcelWriterTableBuilder	table()
ExcelWriterTableBuilder	table(Integer tableNo)
ExcelWriterSheetBuilder	useDefaultStyle(Boolean useDefaultStyle)	Use the default style.Default is true.

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

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

构造器详细资料

ExcelWriterSheetBuilder

public ExcelWriterSheetBuilder()

ExcelWriterSheetBuilder

public ExcelWriterSheetBuilder(ExcelWriter excelWriter)

方法详细资料

relativeHeadRowIndex

public ExcelWriterSheetBuilder relativeHeadRowIndex(Integer relativeHeadRowIndex)

Writes the head relative to the existing contents of the sheet. Indexes are zero-based.

参数:

relativeHeadRowIndex - Integer

返回:

ExcelWriterSheetBuilder

head

public ExcelWriterSheetBuilder head(List<List<String>> head)

You can only choose one of the head(List) and head(Class)

参数:

head - List

返回:

ExcelWriterSheetBuilder

head

public ExcelWriterSheetBuilder head(Class clazz)

You can only choose one of the head(List) and head(Class)

参数:

clazz - Class

返回:

ExcelWriterSheetBuilder

needHead

public ExcelWriterSheetBuilder needHead(Boolean needHead)

useDefaultStyle

public ExcelWriterSheetBuilder useDefaultStyle(Boolean useDefaultStyle)

Use the default style.Default is true.

参数:

useDefaultStyle - Boolean

返回:

ExcelWriterSheetBuilder

automaticMergeHead

public ExcelWriterSheetBuilder automaticMergeHead(Boolean automaticMergeHead)

Whether to automatically merge headers.Default is true.

参数:

automaticMergeHead - Boolean

返回:

ExcelWriterSheetBuilder

registerConverter

public ExcelWriterSheetBuilder registerConverter(Converter converter)

Custom type conversions override the default.

参数:

converter - Converter

返回:

ExcelWriterSheetBuilder

registerWriteHandler

public ExcelWriterSheetBuilder registerWriteHandler(WriteHandler writeHandler)

Custom write handler

参数:

writeHandler - WriteHandler

返回:

ExcelWriterSheetBuilder

sheetNo

public ExcelWriterSheetBuilder sheetNo(Integer sheetNo)

Starting from 0

参数:

sheetNo - Integer

返回:

ExcelWriterSheetBuilder

sheetName

public ExcelWriterSheetBuilder sheetName(String sheetName)

sheet name

参数:

sheetName - String

返回:

ExcelWriterSheetBuilder

excludeColumnIndexes

public ExcelWriterSheetBuilder excludeColumnIndexes(Collection<Integer> excludeColumnIndexes)

Ignore the custom columns.

参数:

excludeColumnIndexes - Collection

返回:

ExcelWriterSheetBuilder

excludeColumnFiledNames

public ExcelWriterSheetBuilder excludeColumnFiledNames(Collection<String> excludeColumnFiledNames)

Ignore the custom columns.

参数:

excludeColumnFiledNames - Collection

返回:

ExcelWriterSheetBuilder

includeColumnIndexes

public ExcelWriterSheetBuilder includeColumnIndexes(Collection<Integer> includeColumnIndexes)

Only output the custom columns.

参数:

includeColumnIndexes - Collection

返回:

ExcelWriterSheetBuilder

includeColumnFiledNames

public ExcelWriterSheetBuilder includeColumnFiledNames(Collection<String> includeColumnFiledNames)

Only output the custom columns.

参数:

includeColumnFiledNames - Collection

返回:

ExcelWriterSheetBuilder

build

public WriteSheet build()

doWrite

public void doWrite(List data)

doFill

public void doFill(Object data)

doFill

public void doFill(Object data,
 FillConfig fillConfig)

table

public ExcelWriterTableBuilder table()

table

public ExcelWriterTableBuilder table(Integer tableNo)