cn.orionsec.kit.office.excel.reader

Class ExcelLambdaReader<T>

java.lang.Object

cn.orionsec.kit.office.excel.reader.BaseExcelReader<Pair<Function<?,?>,BiConsumer<T,?>>,T>

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

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable, Iterable<T>

public class ExcelLambdaReader<T>
extends BaseExcelReader<Pair<Function<?,?>,BiConsumer<T,?>>,T>

excel lambda 读取器

支持高级数据类型

Excels.getCellValue(Cell, ExcelReadType, CellOption)

Since:

2021/9/13 10:53

Version:

1.0.0

Author:

Jiahang Li

Field Summary

Fields

Modifier and Type	Field and Description
protected Map<Integer,Pair<Function<?,?>,BiConsumer<T,?>>>	mapping 映射 key: column value: convert consumer
protected boolean	nullInvoke 为 null 是否调用
protected Supplier<T>	supplier supplier

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
	ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Consumer<T> consumer, Supplier<T> supplier)
protected	ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, List<T> store, Consumer<T> consumer, Supplier<T> supplier)
	ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, List<T> store, Supplier<T> supplier)
	ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Supplier<T> supplier)

Method Summary

Modifier and Type	Method and Description
static <T> ExcelLambdaReader<T>	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Consumer<T> consumer, Supplier<T> supplier)
static <T> ExcelLambdaReader<T>	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, List<T> store, Supplier<T> supplier)
static <T> ExcelLambdaReader<T>	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Supplier<T> supplier)
ExcelLambdaReader<T>	nullAddEmptyBean() 如果行为 null 是否添加实例对象
ExcelLambdaReader<T>	nullInvoke() 如果列为 null 是否调用 function consumer
<V> ExcelLambdaReader<T>	option(ImportFieldOption option, BiConsumer<T,V> consumer)
<E,V> ExcelLambdaReader<T>	option(ImportFieldOption option, Function<E,V> convert, BiConsumer<T,V> consumer) 映射
<V> ExcelLambdaReader<T>	option(int column, ExcelReadType type, BiConsumer<T,V> consumer)
<E,V> ExcelLambdaReader<T>	option(int column, ExcelReadType type, Function<E,V> convert, BiConsumer<T,V> consumer) 映射
protected T	parserRow(org.apache.poi.ss.usermodel.Row row) 解析行

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

addOption, 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

Field Detail

mapping

protected Map<Integer,Pair<Function<?,?>,BiConsumer<T,?>>> mapping

映射 key: column value: convert consumer

supplier

protected Supplier<T> supplier

supplier

nullInvoke

protected boolean nullInvoke

为 null 是否调用

Constructor Detail

ExcelLambdaReader

public ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         Supplier<T> supplier)

ExcelLambdaReader

public ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         List<T> store,
                         Supplier<T> supplier)

ExcelLambdaReader

public ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook,
                         org.apache.poi.ss.usermodel.Sheet sheet,
                         Consumer<T> consumer,
                         Supplier<T> supplier)

ExcelLambdaReader

protected ExcelLambdaReader(org.apache.poi.ss.usermodel.Workbook workbook,
                            org.apache.poi.ss.usermodel.Sheet sheet,
                            List<T> store,
                            Consumer<T> consumer,
                            Supplier<T> supplier)

Method Detail

create

public static <T> ExcelLambdaReader<T> create(org.apache.poi.ss.usermodel.Workbook workbook,
                                              org.apache.poi.ss.usermodel.Sheet sheet,
                                              Supplier<T> supplier)

create

public static <T> ExcelLambdaReader<T> create(org.apache.poi.ss.usermodel.Workbook workbook,
                                              org.apache.poi.ss.usermodel.Sheet sheet,
                                              List<T> store,
                                              Supplier<T> supplier)

create

public static <T> ExcelLambdaReader<T> create(org.apache.poi.ss.usermodel.Workbook workbook,
                                              org.apache.poi.ss.usermodel.Sheet sheet,
                                              Consumer<T> consumer,
                                              Supplier<T> supplier)

nullInvoke

public ExcelLambdaReader<T> nullInvoke()

如果列为 null 是否调用 function consumer

Returns:

this

nullAddEmptyBean

public ExcelLambdaReader<T> nullAddEmptyBean()

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

Returns:

this

option

public <V> ExcelLambdaReader<T> option(int column,
                                       ExcelReadType type,
                                       BiConsumer<T,V> consumer)

option

public <E,V> ExcelLambdaReader<T> option(int column,
                                         ExcelReadType type,
                                         Function<E,V> convert,
                                         BiConsumer<T,V> consumer)

映射

Type Parameters:

E - ExcelReadType

V - ExcelReadType

Parameters:

column - 列

type - 类型

convert - convert

consumer - consumer

Returns:

this

option

public <V> ExcelLambdaReader<T> option(ImportFieldOption option,
                                       BiConsumer<T,V> consumer)

option

public <E,V> ExcelLambdaReader<T> option(ImportFieldOption option,
                                         Function<E,V> convert,
                                         BiConsumer<T,V> consumer)

映射

Type Parameters:

E - ExcelReadType

V - ExcelReadType

Parameters:

option - 配置

convert - convert

consumer - consumer

Returns:

this

parserRow

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

Description copied from class: BaseExcelReader

解析行

Specified by:

parserRow in class BaseExcelReader<Pair<Function<?,?>,BiConsumer<T,?>>,T>

Parameters:

row - row

Returns:

row