public class ExcelWriter extends Object
1. Create a new empty Excel workbook, write the value to the stream after the value is filled. 2. Edit existing Excel, write the original Excel file, or write it to other places.}
构造器和说明 |
---|
ExcelWriter(GenerateParam generateParam)
已过时。
please use
ExcelWriterBuilder build ExcelWriter |
ExcelWriter(InputStream templateInputStream,
OutputStream outputStream,
ExcelTypeEnum typeEnum,
Boolean needHead)
已过时。
please use
ExcelWriterBuilder build ExcelWriter |
ExcelWriter(InputStream templateInputStream,
OutputStream outputStream,
ExcelTypeEnum typeEnum,
Boolean needHead,
WriteHandler writeHandler)
已过时。
please use
ExcelWriterBuilder build ExcelWriter |
ExcelWriter(OutputStream outputStream,
ExcelTypeEnum typeEnum)
已过时。
please use
ExcelWriterBuilder build ExcelWriter |
ExcelWriter(OutputStream outputStream,
ExcelTypeEnum typeEnum,
boolean needHead)
已过时。
please use
ExcelWriterBuilder build ExcelWriter |
ExcelWriter(WriteWorkbook writeWorkbook)
Create new writer
|
限定符和类型 | 方法和说明 |
---|---|
ExcelWriter |
fill(Object data,
FillConfig fillConfig,
WriteSheet writeSheet)
Fill value to a sheet
|
ExcelWriter |
fill(Object data,
WriteSheet writeSheet)
Fill value to a sheet
|
protected void |
finalize()
Prevents calls to
finish() from freeing the cache |
void |
finish()
Close IO
|
ExcelWriter |
merge(int firstRow,
int lastRow,
int firstCol,
int lastCol)
已过时。
please use
OnceAbsoluteMergeStrategy |
ExcelWriter |
write(List data,
Sheet sheet)
已过时。
please use
write(List, WriteSheet) |
ExcelWriter |
write(List data,
Sheet sheet,
Table table)
已过时。
* @deprecated please use
write(List, WriteSheet,WriteTable) |
ExcelWriter |
write(List data,
WriteSheet writeSheet)
Write data to a sheet
|
ExcelWriter |
write(List data,
WriteSheet writeSheet,
WriteTable writeTable)
Write value to a sheet
|
ExcelWriter |
write0(List data,
Sheet sheet)
已过时。
please use
write(List, WriteSheet) |
ExcelWriter |
write0(List data,
Sheet sheet,
Table table)
已过时。
* @deprecated please use
write(List, WriteSheet,WriteTable) |
ExcelWriter |
write1(List data,
Sheet sheet)
已过时。
please use
write(List, WriteSheet) |
ExcelWriter |
write1(List data,
Sheet sheet,
Table table)
已过时。
* @deprecated please use
write(List, WriteSheet,WriteTable) |
WriteContext |
writeContext()
The context of the entire writing process
|
public ExcelWriter(WriteWorkbook writeWorkbook)
writeWorkbook
- @Deprecated public ExcelWriter(OutputStream outputStream, ExcelTypeEnum typeEnum)
ExcelWriterBuilder
build ExcelWriteroutputStream
- the java OutputStream you wish to write the value totypeEnum
- 03 or 07@Deprecated public ExcelWriter(OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead)
ExcelWriterBuilder
build ExcelWriteroutputStream
- the java OutputStream you wish to write the value totypeEnum
- 03 or 07needHead
- Do you need to write the header to the file?@Deprecated public ExcelWriter(InputStream templateInputStream, OutputStream outputStream, ExcelTypeEnum typeEnum, Boolean needHead)
ExcelWriterBuilder
build ExcelWritertemplateInputStream
- 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 07@Deprecated public ExcelWriter(InputStream templateInputStream, OutputStream outputStream, ExcelTypeEnum typeEnum, Boolean needHead, WriteHandler writeHandler)
ExcelWriterBuilder
build ExcelWritertemplateInputStream
- 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 07writeHandler
- User-defined callback@Deprecated public ExcelWriter(GenerateParam generateParam)
ExcelWriterBuilder
build ExcelWritergenerateParam
- public ExcelWriter write(List data, WriteSheet writeSheet)
data
- Data to be writtenwriteSheet
- Write to this sheetpublic ExcelWriter write(List data, WriteSheet writeSheet, WriteTable writeTable)
data
- Data to be writtenwriteSheet
- Write to this sheetwriteTable
- Write to this tablepublic ExcelWriter fill(Object data, WriteSheet writeSheet)
data
- writeSheet
- public ExcelWriter fill(Object data, FillConfig fillConfig, WriteSheet writeSheet)
data
- fillConfig
- writeSheet
- @Deprecated public ExcelWriter write(List data, Sheet sheet)
write(List, WriteSheet)
data
- Data to be writtensheet
- Write to this sheet@Deprecated public ExcelWriter write(List data, Sheet sheet, Table table)
write(List, WriteSheet,WriteTable)
data
- Data to be writtensheet
- Write to this sheettable
- Write to this table@Deprecated public ExcelWriter write0(List data, Sheet sheet)
write(List, WriteSheet)
data
- Data to be writtensheet
- Write to this sheet@Deprecated public ExcelWriter write0(List data, Sheet sheet, Table table)
write(List, WriteSheet,WriteTable)
data
- Data to be writtensheet
- Write to this sheettable
- Write to this table@Deprecated public ExcelWriter write1(List data, Sheet sheet)
write(List, WriteSheet)
data
- Data to be writtensheet
- Write to this sheet@Deprecated public ExcelWriter write1(List data, Sheet sheet, Table table)
write(List, WriteSheet,WriteTable)
data
- Data to be writtensheet
- Write to this sheettable
- Write to this table@Deprecated public ExcelWriter merge(int firstRow, int lastRow, int firstCol, int lastCol)
OnceAbsoluteMergeStrategy
firstRow
- Index of first rowlastRow
- Index of last row (inclusive), must be equal to or larger than firstRow
firstCol
- Index of first columnlastCol
- Index of last column (inclusive), must be equal to or larger than firstCol
public void finish()
protected void finalize()
finish()
from freeing the cachepublic WriteContext writeContext()
Copyright © 2018–2021 Alibaba Group. All rights reserved.