cn.orionsec.kit.office.excel.reader

Class ExcelArrayReader

java.lang.Object

cn.orionsec.kit.office.excel.reader.BaseExcelReader<Integer,String[]>

cn.orionsec.kit.office.excel.reader.ExcelArrayReader

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable, Iterable<String[]>

public class ExcelArrayReader
extends BaseExcelReader<Integer,String[]>

excel array 读取器

不支持高级数据类型

Excels.getCellValue(Cell)

Since:

2021/1/5 10:04

Version:

1.0.0

Author:

Jiahang Li

Field Summary

Fields

Modifier and Type	Field and Description
protected int[]	columns 读取的列
protected int	columnSize 列数

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

Constructor and Description
ExcelArrayReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet)
ExcelArrayReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Consumer<String[]> consumer)
ExcelArrayReader(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, List<String[]> store)

Method Summary

Modifier and Type	Method and Description
ExcelArrayReader	capacity(int capacity) 设置列容量
ExcelArrayReader	columnOfNull(String text) 设置列为空的值
ExcelArrayReader	columnOfNullToEmpty() 设置列为空的值为 ""
ExcelArrayReader	columns(int... columns) 设置读取的列
static ExcelArrayReader	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet)
static ExcelArrayReader	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, Consumer<String[]> consumer)
static ExcelArrayReader	create(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet sheet, List<String[]> store)
int	getColumnSize()
protected String[]	parserRow(org.apache.poi.ss.usermodel.Row row) 解析行
ExcelArrayReader	rowOfNullToEmpty() 空行返回 长度为0的空数组
ExcelArrayReader	rowOfNullToEmpty(int length) 空行返回 长度为length的空数组
ExcelArrayReader	rowOfNullToEmpty(String[] emptyArray) 空行返回 emptyArray

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

columns

protected int[] columns

读取的列

columnSize

protected int columnSize

列数

Constructor Detail

ExcelArrayReader

public ExcelArrayReader(org.apache.poi.ss.usermodel.Workbook workbook,
                        org.apache.poi.ss.usermodel.Sheet sheet)

ExcelArrayReader

public ExcelArrayReader(org.apache.poi.ss.usermodel.Workbook workbook,
                        org.apache.poi.ss.usermodel.Sheet sheet,
                        List<String[]> store)

ExcelArrayReader

public ExcelArrayReader(org.apache.poi.ss.usermodel.Workbook workbook,
                        org.apache.poi.ss.usermodel.Sheet sheet,
                        Consumer<String[]> consumer)

Method Detail

create

public static ExcelArrayReader create(org.apache.poi.ss.usermodel.Workbook workbook,
                                      org.apache.poi.ss.usermodel.Sheet sheet)

create

public static ExcelArrayReader create(org.apache.poi.ss.usermodel.Workbook workbook,
                                      org.apache.poi.ss.usermodel.Sheet sheet,
                                      List<String[]> store)

create

public static ExcelArrayReader create(org.apache.poi.ss.usermodel.Workbook workbook,
                                      org.apache.poi.ss.usermodel.Sheet sheet,
                                      Consumer<String[]> consumer)

columnOfNull

public ExcelArrayReader columnOfNull(String text)

设置列为空的值

Parameters:

text - text

Returns:

this

columnOfNullToEmpty

public ExcelArrayReader columnOfNullToEmpty()

设置列为空的值为 ""

Returns:

this

See Also:

Strings.EMPTY

rowOfNullToEmpty

public ExcelArrayReader rowOfNullToEmpty()

空行返回 长度为0的空数组

Returns:

this

rowOfNullToEmpty

public ExcelArrayReader rowOfNullToEmpty(int length)

空行返回 长度为length的空数组

Parameters:

length - 长度

Returns:

this

rowOfNullToEmpty

public ExcelArrayReader rowOfNullToEmpty(String[] emptyArray)

空行返回 emptyArray

Parameters:

emptyArray - 数组

Returns:

this

columns

public ExcelArrayReader columns(int... columns)

设置读取的列

Parameters:

columns - 列

Returns:

this

capacity

public ExcelArrayReader capacity(int capacity)

设置列容量

Parameters:

capacity - capacity

Returns:

this

parserRow

protected String[] parserRow(org.apache.poi.ss.usermodel.Row row)

Description copied from class: BaseExcelReader

解析行

Specified by:

parserRow in class BaseExcelReader<Integer,String[]>

Parameters:

row - row

Returns:

row

getColumnSize

public int getColumnSize()