构造器和说明 |
---|
EasyExcelFactory() |
限定符和类型 | 方法和说明 |
---|---|
static ExcelReader |
getReader(InputStream in,
AnalysisEventListener listener)
已过时。
please use
read() build 'ExcelReader' |
static ExcelWriter |
getWriter(OutputStream outputStream)
已过时。
please use
write() |
static ExcelWriter |
getWriter(OutputStream outputStream,
ExcelTypeEnum typeEnum,
boolean needHead)
已过时。
please use
write() |
static ExcelWriter |
getWriterWithTemp(InputStream temp,
OutputStream outputStream,
ExcelTypeEnum typeEnum,
boolean needHead)
已过时。
please use
write() |
static ExcelWriter |
getWriterWithTempAndHandler(InputStream temp,
OutputStream outputStream,
ExcelTypeEnum typeEnum,
boolean needHead,
WriteHandler handler)
已过时。
please use
write() |
static ExcelReaderBuilder |
read()
Build excel the read
|
static ExcelReaderBuilder |
read(File file)
Build excel the read
|
static ExcelReaderBuilder |
read(File file,
Class head,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
read(File file,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
read(InputStream inputStream)
Build excel the read
|
static ExcelReaderBuilder |
read(InputStream inputStream,
Class head,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
read(InputStream inputStream,
ReadListener readListener)
Build excel the read
|
static List<Object> |
read(InputStream in,
Sheet sheet)
已过时。
please use 'EasyExcel.read(in).sheet(sheetNo).doReadSync();'
|
static ExcelReaderBuilder |
read(String pathName)
Build excel the read
|
static ExcelReaderBuilder |
read(String pathName,
Class head,
ReadListener readListener)
Build excel the read
|
static ExcelReaderBuilder |
read(String pathName,
ReadListener readListener)
Build excel the read
|
static void |
readBySax(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(Integer sheetNo)
Build excel the 'readSheet'
|
static ExcelReaderSheetBuilder |
readSheet(Integer sheetNo,
String sheetName)
Build excel the 'readSheet'
|
static ExcelReaderSheetBuilder |
readSheet(String sheetName)
Build excel the 'readSheet'
|
static ExcelWriterBuilder |
write()
Build excel the write
|
static ExcelWriterBuilder |
write(File file)
Build excel the write
|
static ExcelWriterBuilder |
write(File file,
Class head)
Build excel the write
|
static ExcelWriterBuilder |
write(OutputStream outputStream)
Build excel the write
|
static ExcelWriterBuilder |
write(OutputStream outputStream,
Class head)
Build excel the write
|
static ExcelWriterBuilder |
write(String pathName)
Build excel the write
|
static ExcelWriterBuilder |
write(String pathName,
Class head)
Build excel the write
|
static ExcelWriterSheetBuilder |
writerSheet()
Build excel the
writerSheet |
static ExcelWriterSheetBuilder |
writerSheet(Integer sheetNo)
Build excel the
writerSheet |
static ExcelWriterSheetBuilder |
writerSheet(Integer sheetNo,
String sheetName)
Build excel the 'writerSheet'
|
static ExcelWriterSheetBuilder |
writerSheet(String sheetName)
Build excel the 'writerSheet'
|
static ExcelWriterTableBuilder |
writerTable()
Build excel the
writerTable |
static ExcelWriterTableBuilder |
writerTable(Integer tableNo)
Build excel the 'writerTable'
|
@Deprecated public static List<Object> read(InputStream in, Sheet sheet)
in
- the POI filesystem that contains the Workbook stream.sheet
- read sheet.@Deprecated public static void readBySax(InputStream in, Sheet sheet, AnalysisEventListener listener)
in
- the POI filesystem that contains the Workbook stream.sheet
- read sheet.listener
- Callback method after each row is parsed.@Deprecated public static ExcelReader getReader(InputStream in, AnalysisEventListener listener)
read()
build 'ExcelReader'in
- the POI filesystem that contains the Workbook stream.listener
- Callback method after each row is parsed.@Deprecated public static ExcelWriter getWriter(OutputStream outputStream)
write()
outputStream
- the java OutputStream you wish to write the value to.@Deprecated public static ExcelWriter getWriter(OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead)
write()
outputStream
- the java OutputStream you wish to write the value to.typeEnum
- 03 or 07needHead
- Do you need to write the header to the file?@Deprecated public static ExcelWriter getWriterWithTemp(InputStream temp, OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead)
write()
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 totypeEnum
- 03 or 07needHead
- Whether a write header is required@Deprecated public static ExcelWriter getWriterWithTempAndHandler(InputStream temp, OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead, WriteHandler handler)
write()
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 totypeEnum
- 03 or 07needHead
- Whether a write header is requiredhandler
- User-defined callbackpublic static ExcelWriterBuilder write()
public static ExcelWriterBuilder write(File file)
file
- File to writepublic static ExcelWriterBuilder write(File file, Class head)
file
- File to writehead
- Annotate the class for configuration informationpublic static ExcelWriterBuilder write(String pathName)
pathName
- File path to writepublic static ExcelWriterBuilder write(String pathName, Class head)
pathName
- File path to writehead
- Annotate the class for configuration informationpublic static ExcelWriterBuilder write(OutputStream outputStream)
outputStream
- Output stream to writepublic static ExcelWriterBuilder write(OutputStream outputStream, Class head)
outputStream
- Output stream to writehead
- Annotate the class for configuration information.public static ExcelWriterSheetBuilder writerSheet()
writerSheet
public static ExcelWriterSheetBuilder writerSheet(Integer sheetNo)
writerSheet
sheetNo
- Index of sheet,0 base.public static ExcelWriterSheetBuilder writerSheet(String sheetName)
sheetName
- The name of sheet.public static ExcelWriterSheetBuilder writerSheet(Integer sheetNo, String sheetName)
sheetNo
- Index of sheet,0 base.sheetName
- The name of sheet.public static ExcelWriterTableBuilder writerTable()
writerTable
public static ExcelWriterTableBuilder writerTable(Integer tableNo)
tableNo
- Index of table,0 base.public static ExcelReaderBuilder read()
public static ExcelReaderBuilder read(File file)
file
- File to read.public static ExcelReaderBuilder read(File file, ReadListener readListener)
file
- File to read.readListener
- Read listener.public static ExcelReaderBuilder read(File file, Class head, ReadListener readListener)
file
- File to read.head
- Annotate the class for configuration information.readListener
- Read listener.public static ExcelReaderBuilder read(String pathName)
pathName
- File path to read.public static ExcelReaderBuilder read(String pathName, ReadListener readListener)
pathName
- File path to read.readListener
- Read listener.public static ExcelReaderBuilder read(String pathName, Class head, ReadListener readListener)
pathName
- File path to read.head
- Annotate the class for configuration information.readListener
- Read listener.public static ExcelReaderBuilder read(InputStream inputStream)
inputStream
- Input stream to read.public static ExcelReaderBuilder read(InputStream inputStream, ReadListener readListener)
inputStream
- Input stream to read.readListener
- Read listener.public static ExcelReaderBuilder read(InputStream inputStream, Class head, ReadListener readListener)
inputStream
- Input stream to read.head
- Annotate the class for configuration information.readListener
- Read listener.public static ExcelReaderSheetBuilder readSheet()
public static ExcelReaderSheetBuilder readSheet(Integer sheetNo)
sheetNo
- Index of sheet,0 base.public static ExcelReaderSheetBuilder readSheet(String sheetName)
sheetName
- The name of sheet.public static ExcelReaderSheetBuilder readSheet(Integer sheetNo, String sheetName)
sheetNo
- Index of sheet,0 base.sheetName
- The name of sheet.Copyright © 2018–2021 Alibaba Group. All rights reserved.