org.dromara.hutool.poi.excel.writer

Class SheetTemplateWriter

java.lang.Object

org.dromara.hutool.poi.excel.writer.SheetTemplateWriter

public class SheetTemplateWriter
extends Object

模板Excel写入器
解析已有模板，并填充模板中的变量为数据

Since:

6.0.0

Author:

Looly

Constructor Summary

Constructors

Constructor and Description
SheetTemplateWriter(org.apache.poi.ss.usermodel.Sheet sheet, ExcelWriteConfig config) 构造

Method Summary

Modifier and Type	Method and Description
SheetTemplateWriter	fillOnce(Map<?,?> rowMap) 填充非列表模板变量（一次性变量）
SheetTemplateWriter	fillRow(Object rowBean) 填充模板行，用于列表填充

Methods inherited from class java.lang.Object

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

Constructor Detail

SheetTemplateWriter

public SheetTemplateWriter(org.apache.poi.ss.usermodel.Sheet sheet,
                           ExcelWriteConfig config)

构造

Parameters:

sheet - Sheet

config - Excel写配置

Method Detail

fillOnce

public SheetTemplateWriter fillOnce(Map<?,?> rowMap)

填充非列表模板变量（一次性变量）

Parameters:

rowMap - 行数据

Returns:

this

fillRow

public SheetTemplateWriter fillRow(Object rowBean)

填充模板行，用于列表填充

Parameters:

rowBean - 行的Bean或Map数据

Returns:

this