bad.robot.excel
Class PoiWorkbookMutator

java.lang.Object
  extended by bad.robot.excel.PoiWorkbookMutator
All Implemented Interfaces:
WorkbookMutator

public class PoiWorkbookMutator
extends Object
implements WorkbookMutator


Constructor Summary
PoiWorkbookMutator(org.apache.poi.ss.usermodel.Workbook workbook)
           
 
Method Summary
 WorkbookMutator appendRowToFirstSheet(Row row)
           
 WorkbookMutator appendRowToSheet(Row row, SheetIndex index)
           
 WorkbookMutator blankCell(Coordinate coordinate)
           
 WorkbookMutator copyRow(org.apache.poi.ss.usermodel.Workbook workbook, org.apache.poi.ss.usermodel.Sheet worksheet, RowIndex from, RowIndex to)
           
 WorkbookMutator insertRowToFirstSheet(Row row, RowIndex index)
           
 WorkbookMutator insertRowToSheet(Row row, RowIndex index, SheetIndex sheet)
           
 WorkbookMutator refreshFormulas()
           
 WorkbookMutator replaceCell(Coordinate coordinate, Boolean value)
           
 WorkbookMutator replaceCell(Coordinate coordinate, Date date)
           
 WorkbookMutator replaceCell(Coordinate coordinate, Double number)
           
 WorkbookMutator replaceCell(Coordinate coordinate, Formula formula)
           
 WorkbookMutator replaceCell(Coordinate coordinate, Hyperlink hyperlink)
           
 WorkbookMutator replaceCell(Coordinate coordinate, String text)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

PoiWorkbookMutator

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

blankCell

public WorkbookMutator blankCell(Coordinate coordinate)
Specified by:
blankCell in interface WorkbookMutator

replaceCell

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

replaceCell

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

replaceCell

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

replaceCell

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

replaceCell

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

replaceCell

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

copyRow

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

insertRowToFirstSheet

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

insertRowToSheet

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

appendRowToFirstSheet

public WorkbookMutator appendRowToFirstSheet(Row row)
Specified by:
appendRowToFirstSheet in interface WorkbookMutator

appendRowToSheet

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

refreshFormulas

public WorkbookMutator refreshFormulas()
Specified by:
refreshFormulas in interface WorkbookMutator


Copyright © 2012. All Rights Reserved.