bad.robot.excel.workbook
Class PoiWorkbook

java.lang.Object
  extended by bad.robot.excel.workbook.PoiWorkbook
All Implemented Interfaces:
Editable

public class PoiWorkbook
extends Object
implements Editable


Constructor Summary
PoiWorkbook(File file)
           
PoiWorkbook(InputStream stream)
           
PoiWorkbook(org.apache.poi.ss.usermodel.Workbook workbook)
           
PoiWorkbook(WorkbookType type)
           
 
Method Summary
 PoiWorkbook appendRowToFirstSheet(Row row)
           
 PoiWorkbook appendRowToSheet(Row row, SheetIndex index)
           
 PoiWorkbook blankCell(Coordinate coordinate)
           
 PoiWorkbook copyRow(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet worksheet, RowIndex from, RowIndex to)
           
 PoiWorkbook insertRowToFirstSheet(Row row, RowIndex index)
           
 PoiWorkbook insertRowToSheet(Row row, RowIndex index, SheetIndex sheet)
           
 Editable insertSheet()
           
 Editable insertSheet(String name)
           
 PoiWorkbook refreshFormulas()
           
 PoiWorkbook replaceCell(Coordinate coordinate, Boolean value)
           
 PoiWorkbook replaceCell(Coordinate coordinate, Cell cell)
           
 PoiWorkbook replaceCell(Coordinate coordinate, Date date)
           
 PoiWorkbook replaceCell(Coordinate coordinate, Double number)
           
 PoiWorkbook replaceCell(Coordinate coordinate, Formula formula)
           
 PoiWorkbook replaceCell(Coordinate coordinate, Hyperlink hyperlink)
           
 PoiWorkbook replaceCell(Coordinate coordinate, String text)
           
 org.apache.poi.ss.usermodel.Workbook workbook()
          Accessor to expose the underlying Poi workbook in case I've missed something and clients need to work with the raw workbook directly.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

PoiWorkbook

public PoiWorkbook(WorkbookType type)

PoiWorkbook

public PoiWorkbook(InputStream stream)
            throws IOException
Throws:
IOException

PoiWorkbook

public PoiWorkbook(File file)
            throws IOException
Throws:
IOException

PoiWorkbook

public PoiWorkbook(org.apache.poi.ss.usermodel.Workbook workbook)
Method Detail

blankCell

public PoiWorkbook blankCell(Coordinate coordinate)
Specified by:
blankCell in interface Editable

replaceCell

public PoiWorkbook replaceCell(Coordinate coordinate,
                               Cell cell)
Specified by:
replaceCell in interface Editable

replaceCell

public PoiWorkbook replaceCell(Coordinate coordinate,
                               String text)
Specified by:
replaceCell in interface Editable

replaceCell

public PoiWorkbook replaceCell(Coordinate coordinate,
                               Formula formula)
Specified by:
replaceCell in interface Editable

replaceCell

public PoiWorkbook replaceCell(Coordinate coordinate,
                               Date date)
Specified by:
replaceCell in interface Editable

replaceCell

public PoiWorkbook replaceCell(Coordinate coordinate,
                               Double number)
Specified by:
replaceCell in interface Editable

replaceCell

public PoiWorkbook replaceCell(Coordinate coordinate,
                               Hyperlink hyperlink)
Specified by:
replaceCell in interface Editable

replaceCell

public PoiWorkbook replaceCell(Coordinate coordinate,
                               Boolean value)
Specified by:
replaceCell in interface Editable

copyRow

public PoiWorkbook copyRow(org.apache.poi.ss.usermodel.Workbook workbook,
                           org.apache.poi.ss.usermodel.Sheet worksheet,
                           RowIndex from,
                           RowIndex to)
Specified by:
copyRow in interface Editable

insertSheet

public Editable insertSheet(String name)
Specified by:
insertSheet in interface Editable

insertSheet

public Editable insertSheet()
Specified by:
insertSheet in interface Editable

insertRowToFirstSheet

public PoiWorkbook insertRowToFirstSheet(Row row,
                                         RowIndex index)
Specified by:
insertRowToFirstSheet in interface Editable

insertRowToSheet

public PoiWorkbook insertRowToSheet(Row row,
                                    RowIndex index,
                                    SheetIndex sheet)
Specified by:
insertRowToSheet in interface Editable

appendRowToFirstSheet

public PoiWorkbook appendRowToFirstSheet(Row row)
Specified by:
appendRowToFirstSheet in interface Editable

appendRowToSheet

public PoiWorkbook appendRowToSheet(Row row,
                                    SheetIndex index)
Specified by:
appendRowToSheet in interface Editable

refreshFormulas

public PoiWorkbook refreshFormulas()
Specified by:
refreshFormulas in interface Editable

workbook

public org.apache.poi.ss.usermodel.Workbook workbook()
Accessor to expose the underlying Poi workbook in case I've missed something and clients need to work with the raw workbook directly. Try not to use this



Copyright © 2013. All Rights Reserved.