com.sh.wf.excel

类 EasyExcelFactory

java.lang.Object

com.sh.wf.excel.EasyExcelFactory

直接已知子类:

EasyExcel

public class EasyExcelFactory
extends java.lang.Object

Reader and writer factory class

Quick start

Read

Sample1

Sample2

Write

Sample1

Sample2

构造器概要

构造器

构造器和说明
EasyExcelFactory()

方法概要

限定符和类型	方法和说明
static ExcelReader	getReader(java.io.InputStream in, AnalysisEventListener listener) 已过时。 please use read() build 'ExcelReader'
static ExcelWriter	getWriter(java.io.OutputStream outputStream) 已过时。 please use write()
static ExcelWriter	getWriter(java.io.OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead) 已过时。 please use write()
static ExcelWriter	getWriterWithTemp(java.io.InputStream temp, java.io.OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead) 已过时。 please use write()
static ExcelWriter	getWriterWithTempAndHandler(java.io.InputStream temp, java.io.OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead, WriteHandler handler) 已过时。 please use write()
static ExcelReaderBuilder	read() Build excel the read
static ExcelReaderBuilder	read(java.io.File file) Build excel the read
static ExcelReaderBuilder	read(java.io.File file, java.lang.Class head, ReadListener readListener) Build excel the read
static ExcelReaderBuilder	read(java.io.File file, ReadListener readListener) Build excel the read
static ExcelReaderBuilder	read(java.io.InputStream inputStream) Build excel the read
static ExcelReaderBuilder	read(java.io.InputStream inputStream, java.lang.Class head, ReadListener readListener) Build excel the read
static ExcelReaderBuilder	read(java.io.InputStream inputStream, ReadListener readListener) Build excel the read
static java.util.List<java.lang.Object>	read(java.io.InputStream in, Sheet sheet) 已过时。 please use 'EasyExcel.read(in).sheet(sheetNo).doReadSync();'
static ExcelReaderBuilder	read(java.lang.String pathName) Build excel the read
static ExcelReaderBuilder	read(java.lang.String pathName, java.lang.Class head, ReadListener readListener) Build excel the read
static ExcelReaderBuilder	read(java.lang.String pathName, ReadListener readListener) Build excel the read
static void	readBySax(java.io.InputStream in, Sheet sheet, AnalysisEventListener listener) 已过时。 please use 'EasyExcel.read(in,head,listener).sheet(sheetNo).doRead();'
static ExcelReaderSheetBuilder	readSheet() Build excel the 'readSheet'
static ExcelReaderSheetBuilder	readSheet(java.lang.Integer sheetNo) Build excel the 'readSheet'
static ExcelReaderSheetBuilder	readSheet(java.lang.Integer sheetNo, java.lang.String sheetName) Build excel the 'readSheet'
static ExcelReaderSheetBuilder	readSheet(java.lang.String sheetName) Build excel the 'readSheet'
static ExcelWriterBuilder	write() Build excel the write
static ExcelWriterBuilder	write(java.io.File file) Build excel the write
static ExcelWriterBuilder	write(java.io.File file, java.lang.Class head) Build excel the write
static ExcelWriterBuilder	write(java.io.OutputStream outputStream) Build excel the write
static ExcelWriterBuilder	write(java.io.OutputStream outputStream, java.lang.Class head) Build excel the write
static ExcelWriterBuilder	write(java.lang.String pathName) Build excel the write
static ExcelWriterBuilder	write(java.lang.String pathName, java.lang.Class head) Build excel the write
static ExcelWriterSheetBuilder	writerSheet() Build excel the writerSheet
static ExcelWriterSheetBuilder	writerSheet(java.lang.Integer sheetNo) Build excel the writerSheet
static ExcelWriterSheetBuilder	writerSheet(java.lang.Integer sheetNo, java.lang.String sheetName) Build excel the 'writerSheet'
static ExcelWriterSheetBuilder	writerSheet(java.lang.String sheetName) Build excel the 'writerSheet'
static ExcelWriterTableBuilder	writerTable() Build excel the writerTable
static ExcelWriterTableBuilder	writerTable(java.lang.Integer tableNo) Build excel the 'writerTable'

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

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

构造器详细资料

EasyExcelFactory

public EasyExcelFactory()

方法详细资料

read

@Deprecated
public static java.util.List<java.lang.Object> read(java.io.InputStream in,
                                                                 Sheet sheet)

已过时。 please use 'EasyExcel.read(in).sheet(sheetNo).doReadSync();'

Quickly read small files，no more than 10,000 lines.

参数:

in - the POI filesystem that contains the Workbook stream.

sheet - read sheet.

返回:

analysis result.

readBySax

@Deprecated
public static void readBySax(java.io.InputStream in,
                                          Sheet sheet,
                                          AnalysisEventListener listener)

已过时。 please use 'EasyExcel.read(in,head,listener).sheet(sheetNo).doRead();'

Parsing large file

参数:

in - the POI filesystem that contains the Workbook stream.

sheet - read sheet.

listener - Callback method after each row is parsed.

getReader

@Deprecated
public static ExcelReader getReader(java.io.InputStream in,
                                                 AnalysisEventListener listener)

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

Get ExcelReader.

参数:

in - the POI filesystem that contains the Workbook stream.

listener - Callback method after each row is parsed.

返回:

ExcelReader.

getWriter

@Deprecated
public static ExcelWriter getWriter(java.io.OutputStream outputStream)

已过时。 please use write()

Get ExcelWriter

参数:

outputStream - the java OutputStream you wish to write the value to.

返回:

new ExcelWriter.

getWriter

@Deprecated
public static ExcelWriter getWriter(java.io.OutputStream outputStream,
                                                 ExcelTypeEnum typeEnum,
                                                 boolean needHead)

已过时。 please use write()

Get ExcelWriter

参数:

outputStream - the java OutputStream you wish to write the value to.

typeEnum - 03 or 07

needHead - Do you need to write the header to the file?

返回:

new ExcelWriter

getWriterWithTemp

@Deprecated
public static ExcelWriter getWriterWithTemp(java.io.InputStream temp,
                                                         java.io.OutputStream outputStream,
                                                         ExcelTypeEnum typeEnum,
                                                         boolean needHead)

已过时。 please use write()

Get ExcelWriter with a template file

参数:

temp - Append value after a POI file , Can be null（the template POI filesystem that contains the Workbook stream)

outputStream - the java OutputStream you wish to write the value to

typeEnum - 03 or 07

needHead - Whether a write header is required

返回:

new ExcelWriter

getWriterWithTempAndHandler

@Deprecated
public static ExcelWriter getWriterWithTempAndHandler(java.io.InputStream temp,
                                                                   java.io.OutputStream outputStream,
                                                                   ExcelTypeEnum typeEnum,
                                                                   boolean needHead,
                                                                   WriteHandler handler)

已过时。 please use write()

Get ExcelWriter with a template file

参数:

temp - Append value after a POI file , Can be null（the template POI filesystem that contains the Workbook stream)

outputStream - the java OutputStream you wish to write the value to

typeEnum - 03 or 07

needHead - Whether a write header is required

handler - User-defined callback

返回:

new ExcelWriter

write

public static ExcelWriterBuilder write()

Build excel the write

返回:

ExcelWriterBuilder

write

public static ExcelWriterBuilder write(java.io.File file)

Build excel the write

参数:

file - File to write

返回:

Excel writer builder

write

public static ExcelWriterBuilder write(java.io.File file,
                                       java.lang.Class head)

Build excel the write

参数:

file - File to write

head - Annotate the class for configuration information

返回:

Excel writer builder

write

public static ExcelWriterBuilder write(java.lang.String pathName)

Build excel the write

参数:

pathName - File path to write

返回:

Excel writer builder

write

public static ExcelWriterBuilder write(java.lang.String pathName,
                                       java.lang.Class head)

Build excel the write

参数:

pathName - File path to write

head - Annotate the class for configuration information

返回:

Excel writer builder

write

public static ExcelWriterBuilder write(java.io.OutputStream outputStream)

Build excel the write

参数:

outputStream - Output stream to write

返回:

Excel writer builder

write

public static ExcelWriterBuilder write(java.io.OutputStream outputStream,
                                       java.lang.Class head)

Build excel the write

参数:

outputStream - Output stream to write

head - Annotate the class for configuration information.

返回:

Excel writer builder

writerSheet

public static ExcelWriterSheetBuilder writerSheet()

Build excel the writerSheet

返回:

Excel sheet writer builder

writerSheet

public static ExcelWriterSheetBuilder writerSheet(java.lang.Integer sheetNo)

Build excel the writerSheet

参数:

sheetNo - Index of sheet,0 base.

返回:

Excel sheet writer builder.

writerSheet

public static ExcelWriterSheetBuilder writerSheet(java.lang.String sheetName)

Build excel the 'writerSheet'

参数:

sheetName - The name of sheet.

返回:

Excel sheet writer builder.

writerSheet

public static ExcelWriterSheetBuilder writerSheet(java.lang.Integer sheetNo,
                                                  java.lang.String sheetName)

Build excel the 'writerSheet'

参数:

sheetNo - Index of sheet,0 base.

sheetName - The name of sheet.

返回:

Excel sheet writer builder.

writerTable

public static ExcelWriterTableBuilder writerTable()

Build excel the writerTable

返回:

Excel table writer builder.

writerTable

public static ExcelWriterTableBuilder writerTable(java.lang.Integer tableNo)

Build excel the 'writerTable'

参数:

tableNo - Index of table,0 base.

返回:

Excel table writer builder.

read

public static ExcelReaderBuilder read()

Build excel the read

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.io.File file)

Build excel the read

参数:

file - File to read.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.io.File file,
                                      ReadListener readListener)

Build excel the read

参数:

file - File to read.

readListener - Read listener.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.io.File file,
                                      java.lang.Class head,
                                      ReadListener readListener)

Build excel the read

参数:

file - File to read.

head - Annotate the class for configuration information.

readListener - Read listener.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.lang.String pathName)

Build excel the read

参数:

pathName - File path to read.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.lang.String pathName,
                                      ReadListener readListener)

Build excel the read

参数:

pathName - File path to read.

readListener - Read listener.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.lang.String pathName,
                                      java.lang.Class head,
                                      ReadListener readListener)

Build excel the read

参数:

pathName - File path to read.

head - Annotate the class for configuration information.

readListener - Read listener.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.io.InputStream inputStream)

Build excel the read

参数:

inputStream - Input stream to read.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.io.InputStream inputStream,
                                      ReadListener readListener)

Build excel the read

参数:

inputStream - Input stream to read.

readListener - Read listener.

返回:

Excel reader builder.

read

public static ExcelReaderBuilder read(java.io.InputStream inputStream,
                                      java.lang.Class head,
                                      ReadListener readListener)

Build excel the read

参数:

inputStream - Input stream to read.

head - Annotate the class for configuration information.

readListener - Read listener.

返回:

Excel reader builder.

readSheet

public static ExcelReaderSheetBuilder readSheet()

Build excel the 'readSheet'

返回:

Excel sheet reader builder.

readSheet

public static ExcelReaderSheetBuilder readSheet(java.lang.Integer sheetNo)

Build excel the 'readSheet'

参数:

sheetNo - Index of sheet,0 base.

返回:

Excel sheet reader builder.

readSheet

public static ExcelReaderSheetBuilder readSheet(java.lang.String sheetName)

Build excel the 'readSheet'

参数:

sheetName - The name of sheet.

返回:

Excel sheet reader builder.

readSheet

public static ExcelReaderSheetBuilder readSheet(java.lang.Integer sheetNo,
                                                java.lang.String sheetName)

Build excel the 'readSheet'

参数:

sheetNo - Index of sheet,0 base.

sheetName - The name of sheet.

返回:

Excel sheet reader builder.