com.sh.wf.excel

类 ExcelReader

java.lang.Object

com.sh.wf.excel.ExcelReader

public class ExcelReader
extends java.lang.Object

Excel readers are all read in event mode.

构造器概要

构造器

构造器和说明
ExcelReader(AnalysisParam param, AnalysisEventListener eventListener) 已过时。 please use EasyExcelFactory.read() build 'ExcelReader'
ExcelReader(java.io.InputStream in, ExcelTypeEnum excelTypeEnum, java.lang.Object customContent, AnalysisEventListener eventListener) 已过时。 please use EasyExcelFactory.read() build 'ExcelReader'
ExcelReader(java.io.InputStream in, ExcelTypeEnum excelTypeEnum, java.lang.Object customContent, AnalysisEventListener eventListener, boolean trim) 已过时。 please use EasyExcelFactory.read() build 'ExcelReader'
ExcelReader(java.io.InputStream in, java.lang.Object customContent, AnalysisEventListener eventListener) 已过时。 please use EasyExcelFactory.read() build 'ExcelReader'
ExcelReader(java.io.InputStream in, java.lang.Object customContent, AnalysisEventListener eventListener, boolean trim) 已过时。
ExcelReader(ReadWorkbook readWorkbook)

方法概要

限定符和类型	方法和说明
AnalysisContext	analysisContext() Context for the entire execution process
ExcelReadExecutor	excelExecutor() Current executor
void	finish() Complete the entire read file.Release the cache and close stream.
AnalysisContext	getAnalysisContext() 已过时。 please use analysisContext()
java.util.List<Sheet>	getSheets() 已过时。 please use excelExecutor()
void	read() 已过时。 lease use readAll()
ExcelReader	read(java.util.List<ReadSheet> readSheetList) Read multiple sheets.
ExcelReader	read(ReadSheet... readSheet) Parse the specified sheet，SheetNo start from 0
void	read(Sheet sheet) 已过时。 please us read(ReadSheet...)
void	read(Sheet sheet, java.lang.Class clazz) 已过时。 Set the class in the sheet before read
void	readAll() Parse all sheet content by default

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

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

构造器详细资料

ExcelReader

@Deprecated
public ExcelReader(java.io.InputStream in,
                                ExcelTypeEnum excelTypeEnum,
                                java.lang.Object customContent,
                                AnalysisEventListener eventListener)

已过时。 please use EasyExcelFactory.read() build 'ExcelReader'

Create new reader

参数:

in - the POI filesystem that contains the Workbook stream

excelTypeEnum - 03 or 07

customContent - ReadListener.invoke(Object, AnalysisContext)AnalysisContext

eventListener - Callback method after each row is parsed.

ExcelReader

@Deprecated
public ExcelReader(java.io.InputStream in,
                                java.lang.Object customContent,
                                AnalysisEventListener eventListener)

已过时。 please use EasyExcelFactory.read() build 'ExcelReader'

Create new reader

参数:

in - the POI filesystem that contains the Workbook stream

customContent - ReadListener.invoke(Object, AnalysisContext)AnalysisContext

eventListener - Callback method after each row is parsed

ExcelReader

@Deprecated
public ExcelReader(AnalysisParam param,
                                AnalysisEventListener eventListener)

已过时。 please use EasyExcelFactory.read() build 'ExcelReader'

Create new reader

参数:

param - old param Deprecated

eventListener - Callback method after each row is parsed.

ExcelReader

@Deprecated
public ExcelReader(java.io.InputStream in,
                                java.lang.Object customContent,
                                AnalysisEventListener eventListener,
                                boolean trim)

已过时。

ExcelReader

@Deprecated
public ExcelReader(java.io.InputStream in,
                                ExcelTypeEnum excelTypeEnum,
                                java.lang.Object customContent,
                                AnalysisEventListener eventListener,
                                boolean trim)

已过时。 please use EasyExcelFactory.read() build 'ExcelReader'

Create new reader

参数:

in - the POI filesystem that contains the Workbook stream

excelTypeEnum - 03 or 07

customContent - ReadListener.invoke(Object, AnalysisContext)AnalysisContext

eventListener - Callback method after each row is parsed.

trim - The content of the form is empty and needs to be empty. The purpose is to be fault-tolerant, because there are often table contents with spaces that can not be converted into custom types. For example: '1234 ' contain a space cannot be converted to int.

ExcelReader

public ExcelReader(ReadWorkbook readWorkbook)

方法详细资料

read

@Deprecated
public void read()

已过时。 lease use readAll()

Parse all sheet content by default

readAll

public void readAll()

Parse all sheet content by default

read

public ExcelReader read(ReadSheet... readSheet)

Parse the specified sheet，SheetNo start from 0

参数:

readSheet - Read sheet

返回:

ExcelReader

read

public ExcelReader read(java.util.List<ReadSheet> readSheetList)

Read multiple sheets.

参数:

readSheetList - List

返回:

ExcelReader

read

@Deprecated
public void read(Sheet sheet)

已过时。 please us read(ReadSheet...)

Parse the specified sheet，SheetNo start from 1

参数:

sheet - Read sheet

read

@Deprecated
public void read(Sheet sheet,
                              java.lang.Class clazz)

已过时。 Set the class in the sheet before read

Parse the specified sheet

参数:

sheet - Read sheet

clazz - object parsed into each row of value

analysisContext

public AnalysisContext analysisContext()

Context for the entire execution process

返回:

AnalysisContext

excelExecutor

public ExcelReadExecutor excelExecutor()

Current executor

返回:

ExcelReadExecutor

getSheets

@Deprecated
public java.util.List<Sheet> getSheets()

已过时。 please use excelExecutor()

Parse the workBook get all sheets

返回:

workBook all sheets

getAnalysisContext

@Deprecated
public AnalysisContext getAnalysisContext()

已过时。 please use analysisContext()

返回:

AnalysisContext

finish

public void finish()

Complete the entire read file.Release the cache and close stream.