程序包 com.sh.wf.excel

类 ExcelWriter

java.lang.Object
com.sh.wf.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.}

  • 构造器详细资料

  • 方法详细资料

    • 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 - Object
      writeSheet - WriteSheet
      返回:
      ExcelWriter

    • fill

      public ExcelWriter fill(Object data, FillConfig fillConfig, WriteSheet writeSheet)
      Fill value to a sheet
      参数:
      data - Object
      fillConfig - FillConfig
      writeSheet - WriteSheet
      返回:
      ExcelWriter

    • write

      @Deprecated public ExcelWriter write(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(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(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(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(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(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

    • finalize

      protected void finalize()
      Prevents calls to finish() from freeing the cache
      覆盖:
      finalize 在类中 Object

    • writeContext

      public WriteContext writeContext()
      The context of the entire writing process
      返回:
      WriteContext