com.sh.wf.excel

类 ExcelWriter

java.lang.Object

com.sh.wf.excel.ExcelWriter

public class ExcelWriter
extends java.lang.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.}
 

构造器概要

构造器

构造器和说明
ExcelWriter(GenerateParam generateParam) 已过时。 please use ExcelWriterBuilder build ExcelWriter
ExcelWriter(java.io.InputStream templateInputStream, java.io.OutputStream outputStream, ExcelTypeEnum typeEnum, java.lang.Boolean needHead) 已过时。
ExcelWriter(java.io.InputStream templateInputStream, java.io.OutputStream outputStream, ExcelTypeEnum typeEnum, java.lang.Boolean needHead, WriteHandler writeHandler) 已过时。
ExcelWriter(java.io.OutputStream outputStream, ExcelTypeEnum typeEnum) 已过时。 please use ExcelWriterBuilder build ExcelWriter
ExcelWriter(java.io.OutputStream outputStream, ExcelTypeEnum typeEnum, boolean needHead) 已过时。 please use ExcelWriterBuilder build ExcelWriter
ExcelWriter(WriteWorkbook writeWorkbook) Create new writer

方法概要

限定符和类型	方法和说明
ExcelWriter	fill(java.lang.Object data, FillConfig fillConfig, WriteSheet writeSheet) Fill value to a sheet
ExcelWriter	fill(java.lang.Object data, WriteSheet writeSheet) Fill value to a sheet
void	finish() Close IO
ExcelWriter	merge(int firstRow, int lastRow, int firstCol, int lastCol) 已过时。 please useOnceAbsoluteMergeStrategy
ExcelWriter	write(java.util.List data, Sheet sheet) 已过时。 please use write(List, WriteSheet)
ExcelWriter	write(java.util.List data, Sheet sheet, Table table) 已过时。 * @deprecated please use write(List, WriteSheet,WriteTable)
ExcelWriter	write(java.util.List data, WriteSheet writeSheet) Write data to a sheet
ExcelWriter	write(java.util.List data, WriteSheet writeSheet, WriteTable writeTable) Write value to a sheet
ExcelWriter	write0(java.util.List data, Sheet sheet) 已过时。 please use write(List, WriteSheet)
ExcelWriter	write0(java.util.List data, Sheet sheet, Table table) 已过时。 * @deprecated please use write(List, WriteSheet,WriteTable)
ExcelWriter	write1(java.util.List data, Sheet sheet) 已过时。 please use write(List, WriteSheet)
ExcelWriter	write1(java.util.List data, Sheet sheet, Table table) 已过时。 * @deprecated please use write(List, WriteSheet,WriteTable)
WriteContext	writeContext() The context of the entire writing process

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

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

构造器详细资料

ExcelWriter

public ExcelWriter(WriteWorkbook writeWorkbook)

Create new writer

参数:

writeWorkbook - WriteWorkbook

ExcelWriter

@Deprecated
public ExcelWriter(java.io.OutputStream outputStream,
                                ExcelTypeEnum typeEnum)

已过时。 please use ExcelWriterBuilder build ExcelWriter

Create new writer

参数:

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

typeEnum - 03 or 07

ExcelWriter

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

已过时。 please use ExcelWriterBuilder build ExcelWriter

Create 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(java.io.InputStream templateInputStream,
                                java.io.OutputStream outputStream,
                                ExcelTypeEnum typeEnum,
                                java.lang.Boolean needHead)

已过时。

ExcelWriter

@Deprecated
public ExcelWriter(java.io.InputStream templateInputStream,
                                java.io.OutputStream outputStream,
                                ExcelTypeEnum typeEnum,
                                java.lang.Boolean needHead,
                                WriteHandler writeHandler)

已过时。

ExcelWriter

@Deprecated
public ExcelWriter(GenerateParam generateParam)

已过时。 please use ExcelWriterBuilder build ExcelWriter

参数:

generateParam - GenerateParam

方法详细资料

write

public ExcelWriter write(java.util.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(java.util.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(java.lang.Object data,
                        WriteSheet writeSheet)

Fill value to a sheet

参数:

data - Object

writeSheet - WriteSheet

返回:

ExcelWriter

fill

public ExcelWriter fill(java.lang.Object data,
                        FillConfig fillConfig,
                        WriteSheet writeSheet)

Fill value to a sheet

参数:

data - Object

fillConfig - FillConfig

writeSheet - WriteSheet

返回:

ExcelWriter

write

@Deprecated
public ExcelWriter write(java.util.List data,
                                      Sheet sheet)

已过时。 please use write(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(java.util.List data,
                                      Sheet sheet,
                                      Table table)

已过时。 * @deprecated please use write(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(java.util.List data,
                                       Sheet sheet)

已过时。 please use write(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(java.util.List data,
                                       Sheet sheet,
                                       Table table)

已过时。 * @deprecated please use write(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(java.util.List data,
                                       Sheet sheet)

已过时。 please use write(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(java.util.List data,
                                       Sheet sheet,
                                       Table table)

已过时。 * @deprecated please use write(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 than firstRow

firstCol - Index of first column

lastCol - Index of last column (inclusive), must be equal to or larger than firstCol

返回:

ExcelWriter

finish

public void finish()

Close IO

writeContext

public WriteContext writeContext()

The context of the entire writing process

返回:

WriteContext