cn.orionsec.kit.office.excel.reader

Class ExcelBeanReader<T>

java.lang.Object

cn.orionsec.kit.office.excel.reader.BaseExcelReader<String,T>

cn.orionsec.kit.office.excel.reader.ExcelBeanReader<T>

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable, Iterable<T>

public class ExcelBeanReader<T>
extends BaseExcelReader<String,T>

excel bean 读取器

支持高级数据类型

Excels.getCellValue(Cell, ExcelReadType, CellOption)

Since:

2021/1/6 17:10

Version:

1.0.0

Author:

Jiahang Li

Field Summary

Fields inherited from class cn.orionsec.kit.office.excel.reader.BaseExcelReader

consumer, currentIndex, end, init, iterator, lines, options, pictureParser, rowIndex, rowNum, rows, sheet, store, streaming, trim, workbook

Constructor Summary

Constructors

Modifier	Constructor and Description
	ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Class<T> targetClass)
	ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Class<T> targetClass, Consumer<T> consumer)
	ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Class<T> targetClass, List<T> store)
protected	ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Class<T> targetClass, List<T> rows, Consumer<T> consumer)

Method Summary

Modifier and Type	Method and Description
protected void	addOption(String field, ImportFieldOption option) 添加配置
static <T> ExcelBeanReader<T>	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Class<T> targetClass)
static <T> ExcelBeanReader<T>	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Class<T> targetClass, Consumer<T> consumer)
static <T> ExcelBeanReader<T>	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Class<T> targetClass, List<T> rows)
ExcelBeanReader<T>	nullAddEmptyBean() 如果行为 null 是否添加实例对象
ExcelBeanReader<T>	nullInvoke() 如果列为 null 是否调用 setter(null)
ExcelBeanReader<T>	option(int column, String field, ExcelReadType type) 添加配置
ExcelBeanReader<T>	option(String field, ImportFieldOption option) 添加配置
protected T	parserRow(org.apache.poi.ss.usermodel.Row row) 解析行

Methods inherited from class cn.orionsec.kit.office.excel.reader.BaseExcelReader

checkHasPicture, checkInit, checkStreamingSupportType, clear, close, getLines, getPicture, getRowNum, getRows, getSheet, getWorkbook, init, iterator, nextRow, read, read, readRow, recalculationFormula, skip, skip, trim

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Constructor Detail

ExcelBeanReader

public ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook,
                       org.apache.poi.ss.usermodel.Sheet sheet,
                       Class<T> targetClass)

ExcelBeanReader

public ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook,
                       org.apache.poi.ss.usermodel.Sheet sheet,
                       Class<T> targetClass,
                       List<T> store)

ExcelBeanReader

public ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook,
                       org.apache.poi.ss.usermodel.Sheet sheet,
                       Class<T> targetClass,
                       Consumer<T> consumer)

ExcelBeanReader

protected ExcelBeanReader(org.apache.poi.ss.usermodel.Workbook workbook,
                          org.apache.poi.ss.usermodel.Sheet sheet,
                          Class<T> targetClass,
                          List<T> rows,
                          Consumer<T> consumer)

Method Detail

create

public static <T> ExcelBeanReader<T> create(org.apache.poi.ss.usermodel.Workbook workbook,
                                            org.apache.poi.ss.usermodel.Sheet sheet,
                                            Class<T> targetClass)

create

public static <T> ExcelBeanReader<T> create(org.apache.poi.ss.usermodel.Workbook workbook,
                                            org.apache.poi.ss.usermodel.Sheet sheet,
                                            Class<T> targetClass,
                                            List<T> rows)

create

public static <T> ExcelBeanReader<T> create(org.apache.poi.ss.usermodel.Workbook workbook,
                                            org.apache.poi.ss.usermodel.Sheet sheet,
                                            Class<T> targetClass,
                                            Consumer<T> consumer)

nullInvoke

public ExcelBeanReader<T> nullInvoke()

如果列为 null 是否调用 setter(null)

Returns:

this

nullAddEmptyBean

public ExcelBeanReader<T> nullAddEmptyBean()

如果行为 null 是否添加实例对象

Returns:

this

option

public ExcelBeanReader<T> option(String field,
                                 ImportFieldOption option)

添加配置

Parameters:

field - field

option - 配置

Returns:

this

option

public ExcelBeanReader<T> option(int column,
                                 String field,
                                 ExcelReadType type)

添加配置

Parameters:

column - 列

field - field

type - 类型

Returns:

this

addOption

protected void addOption(String field,
                         ImportFieldOption option)

添加配置

Overrides:

addOption in class BaseExcelReader<String,T>

Parameters:

field - field

option - 配置

parserRow

protected T parserRow(org.apache.poi.ss.usermodel.Row row)

Description copied from class: BaseExcelReader

解析行

Specified by:

parserRow in class BaseExcelReader<String,T>

Parameters:

row - row

Returns:

row