com.alibaba.excel
类 ExcelWriter
- java.lang.Object
-
- com.alibaba.excel.ExcelWriter
public class ExcelWriter extends Object
Excel Writer This tool is used to write value out to Excel via POI. This object can perform the following two functions.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.}
- 作者:
- jipengfei
-
构造器概要
构造器 构造器和说明 ExcelWriter(GenerateParam generateParam)
已过时。please useExcelWriterBuilder
build ExcelWriterExcelWriter(InputStream templateInputStream, OutputStream outputStream, ExcelTypeEnum typeEnum, Boolean needHead)
已过时。please useExcelWriterBuilder
build ExcelWriterExcelWriter(InputStream templateInputStream, OutputStream outputStream, ExcelTypeEnum typeEnum, Boolean needHead, WriteHandler writeHandler)
已过时。please useExcelWriterBuilder
build ExcelWriterExcelWriter(OutputStream outputStream, ExcelTypeEnum typeEnum)
已过时。please useExcelWriterBuilder
build ExcelWriterExcelWriter(OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead)
已过时。please useExcelWriterBuilder
build ExcelWriterExcelWriter(WriteWorkbook writeWorkbook)
Create new writer
方法概要
所有方法 实例方法 具体方法 已过时的方法 限定符和类型 方法和说明 ExcelWriter
fill(Object data, FillConfig fillConfig, WriteSheet writeSheet)
Fill value to a sheetExcelWriter
fill(Object data, WriteSheet writeSheet)
Fill value to a sheetprotected void
finalize()
Prevents calls tofinish()
from freeing the cachevoid
finish()
Close IOExcelWriter
merge(int firstRow, int lastRow, int firstCol, int lastCol)
已过时。please useOnceAbsoluteMergeStrategy
ExcelWriter
write(List data, Sheet sheet)
已过时。please usewrite(List, WriteSheet)
ExcelWriter
write(List data, Sheet sheet, Table table)
已过时。* @deprecated please usewrite(List, WriteSheet,WriteTable)
ExcelWriter
write(List data, WriteSheet writeSheet)
Write data to a sheetExcelWriter
write(List data, WriteSheet writeSheet, WriteTable writeTable)
Write value to a sheetExcelWriter
write0(List data, Sheet sheet)
已过时。please usewrite(List, WriteSheet)
ExcelWriter
write0(List data, Sheet sheet, Table table)
已过时。* @deprecated please usewrite(List, WriteSheet,WriteTable)
ExcelWriter
write1(List data, Sheet sheet)
已过时。please usewrite(List, WriteSheet)
ExcelWriter
write1(List data, Sheet sheet, Table table)
已过时。* @deprecated please usewrite(List, WriteSheet,WriteTable)
WriteContext
writeContext()
The context of the entire writing process
-
构造器详细资料
ExcelWriter
public ExcelWriter(WriteWorkbook writeWorkbook)
Create new writer- 参数:
-
writeWorkbook
-
ExcelWriter
@Deprecated public ExcelWriter(OutputStream outputStream, ExcelTypeEnum typeEnum)
已过时。 please useExcelWriterBuilder
build ExcelWriterCreate new writer- 参数:
-
outputStream
- the java OutputStream you wish to write the value to -
typeEnum
- 03 or 07
ExcelWriter
@Deprecated public ExcelWriter(OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead)
已过时。 please useExcelWriterBuilder
build ExcelWriterCreate new writer- 参数:
-
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?
ExcelWriter
@Deprecated public ExcelWriter(InputStream templateInputStream, OutputStream outputStream, ExcelTypeEnum typeEnum, Boolean needHead)
已过时。 please useExcelWriterBuilder
build ExcelWriterCreate new writer- 参数:
-
templateInputStream
- 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
ExcelWriter
@Deprecated public ExcelWriter(InputStream templateInputStream, OutputStream outputStream, ExcelTypeEnum typeEnum, Boolean needHead, WriteHandler writeHandler)
已过时。 please useExcelWriterBuilder
build ExcelWriterCreate new writer- 参数:
-
templateInputStream
- 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 -
writeHandler
- User-defined callback
ExcelWriter
@Deprecated public ExcelWriter(GenerateParam generateParam)
已过时。 please useExcelWriterBuilder
build ExcelWriter- 参数:
-
generateParam
-
方法详细资料
write
public ExcelWriter write(List data, WriteSheet writeSheet)
Write data to a sheet- 参数:
-
data
- Data to be written -
writeSheet
- Write to this sheet - 返回:
- this current writer
write
public ExcelWriter write(List data, WriteSheet writeSheet, WriteTable writeTable)
Write value to a sheet- 参数:
-
data
- Data to be written -
writeSheet
- Write to this sheet -
writeTable
- Write to this table - 返回:
- this
fill
public ExcelWriter fill(Object data, WriteSheet writeSheet)
Fill value to a sheet- 参数:
-
data
- -
writeSheet
- - 返回:
fill
public ExcelWriter fill(Object data, FillConfig fillConfig, WriteSheet writeSheet)
Fill value to a sheet- 参数:
-
data
- -
fillConfig
- -
writeSheet
- - 返回:
write
@Deprecated public ExcelWriter write(List data, Sheet sheet)
已过时。 please usewrite(List, WriteSheet)
Write data to a sheet- 参数:
-
data
- Data to be written -
sheet
- Write to this sheet - 返回:
- this current writer
write
@Deprecated public ExcelWriter write(List data, Sheet sheet, Table table)
已过时。 * @deprecated please usewrite(List, WriteSheet,WriteTable)
Write value to a sheet- 参数:
-
data
- Data to be written -
sheet
- Write to this sheet -
table
- Write to this table - 返回:
- this
write0
@Deprecated public ExcelWriter write0(List data, Sheet sheet)
已过时。 please usewrite(List, WriteSheet)
Write data to a sheet- 参数:
-
data
- Data to be written -
sheet
- Write to this sheet - 返回:
- this current writer
write0
@Deprecated public ExcelWriter write0(List data, Sheet sheet, Table table)
已过时。 * @deprecated please usewrite(List, WriteSheet,WriteTable)
Write value to a sheet- 参数:
-
data
- Data to be written -
sheet
- Write to this sheet -
table
- Write to this table - 返回:
- this
write1
@Deprecated public ExcelWriter write1(List data, Sheet sheet)
已过时。 please usewrite(List, WriteSheet)
Write data to a sheet- 参数:
-
data
- Data to be written -
sheet
- Write to this sheet - 返回:
- this current writer
write1
@Deprecated public ExcelWriter write1(List data, Sheet sheet, Table table)
已过时。 * @deprecated please usewrite(List, WriteSheet,WriteTable)
Write value to a sheet- 参数:
-
data
- Data to be written -
sheet
- Write to this sheet -
table
- Write to this table - 返回:
- this
merge
@Deprecated public ExcelWriter merge(int firstRow, int lastRow, int firstCol, int lastCol)
已过时。 please useOnceAbsoluteMergeStrategy
Merge Cells,Indexes are zero-based.- 参数:
-
firstRow
- Index of first row -
lastRow
- Index of last row (inclusive), must be equal to or larger thanfirstRow
-
firstCol
- Index of first column -
lastCol
- Index of last column (inclusive), must be equal to or larger thanfirstCol
finish
public void finish()
Close IO
finalize
protected void finalize()
Prevents calls tofinish()
from freeing the cache
writeContext
public WriteContext writeContext()
The context of the entire writing process- 返回:
Copyright © 2018–2019 Alibaba Group. All rights reserved.