程序包 | 说明 |
---|---|
com.sh.wf.excel | |
com.sh.wf.excel.read.builder |
限定符和类型 | 方法和说明 |
---|---|
static ExcelReaderBuilder |
EasyExcelFactory.read()
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.io.File file)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.io.File file,
java.lang.Class head,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.io.File file,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.io.InputStream inputStream)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.io.InputStream inputStream,
java.lang.Class head,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.io.InputStream inputStream,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.lang.String pathName)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.lang.String pathName,
java.lang.Class head,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
EasyExcelFactory.read(java.lang.String pathName,
ReadListener readListener)
Build excel the read
|
限定符和类型 | 方法和说明 |
---|---|
ExcelReaderBuilder |
ExcelReaderBuilder.autoCloseStream(java.lang.Boolean autoCloseStream)
Default true
|
ExcelReaderBuilder |
ExcelReaderBuilder.autoTrim(java.lang.Boolean autoTrim)
Automatic trim includes sheet name and content
|
ExcelReaderBuilder |
ExcelReaderBuilder.customObject(java.lang.Object customObject)
This object can be read in the Listener
ReadListener.invoke(Object, AnalysisContext)
AnalysisContext.getCustom() |
ExcelReaderBuilder |
ExcelReaderBuilder.excelType(ExcelTypeEnum excelType) |
ExcelReaderBuilder |
ExcelReaderBuilder.file(java.io.File file)
Read file
If 'inputStream' and 'file' all not empty,file first
|
ExcelReaderBuilder |
ExcelReaderBuilder.file(java.io.InputStream inputStream)
Read InputStream
If 'inputStream' and 'file' all not empty,file first
|
ExcelReaderBuilder |
ExcelReaderBuilder.file(java.lang.String pathName)
Read file
If 'inputStream' and 'file' all not empty,file first
|
ExcelReaderBuilder |
ExcelReaderBuilder.head(java.lang.Class clazz)
You can only choose one of the
head(List) and head(Class) |
ExcelReaderBuilder |
ExcelReaderBuilder.head(java.util.List<java.util.List<java.lang.String>> head)
You can only choose one of the
head(List) and head(Class) |
ExcelReaderBuilder |
ExcelReaderBuilder.headRowNumber(java.lang.Integer headRowNumber)
Count the number of added heads when read sheet.
0 - This Sheet has no head ,since the first row are the data
1 - This Sheet has one row head , this is the default
2 - This Sheet has two row head ,since the third row is the data
|
ExcelReaderBuilder |
ExcelReaderBuilder.ignoreEmptyRow(java.lang.Boolean ignoreEmptyRow)
Ignore empty rows.Default is true.
|
ExcelReaderBuilder |
ExcelReaderBuilder.mandatoryUseInputStream(java.lang.Boolean mandatoryUseInputStream)
Mandatory use 'inputStream' .Default is false.
|
ExcelReaderBuilder |
ExcelReaderBuilder.password(java.lang.String password)
Whether the encryption
|
ExcelReaderBuilder |
ExcelReaderBuilder.readCache(ReadCache readCache)
A cache that stores temp data to save memory.
|
ExcelReaderBuilder |
ExcelReaderBuilder.readCacheSelector(ReadCacheSelector readCacheSelector)
Select the cache.Default use
SimpleReadCacheSelector |
ExcelReaderBuilder |
ExcelReaderBuilder.registerConverter(Converter converter)
Custom type conversions override the default.
|
ExcelReaderBuilder |
ExcelReaderBuilder.registerReadListener(ReadListener readListener)
Custom type listener run after default
|
ExcelReaderBuilder |
ExcelReaderBuilder.use1904windowing(java.lang.Boolean use1904windowing)
true if date uses 1904 windowing, or false if using 1900 date windowing.
|
ExcelReaderBuilder |
ExcelReaderBuilder.useDefaultListener(java.lang.Boolean useDefaultListener)
Whether to use the default listener, which is used by default.
|
ExcelReaderBuilder |
ExcelReaderBuilder.xlsxSAXParserFactoryName(java.lang.String xlsxSAXParserFactoryName)
SAXParserFactory used when reading xlsx.
|