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 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, Date value)
           
 WorkbookMutator replaceCell(Coordinate coordinate, Double value)
           
 WorkbookMutator replaceCell(Coordinate coordinate, Formula formula)
           
 WorkbookMutator replaceCell(Coordinate coordinate, String value)
           
 
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

replaceCell

public WorkbookMutator replaceCell(Coordinate coordinate,
                                   String value)
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 value)
Specified by:
replaceCell in interface WorkbookMutator

replaceCell

public WorkbookMutator replaceCell(Coordinate coordinate,
                                   Double 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.