bad.robot.excel.workbook
Class PoiWorkbook
java.lang.Object
bad.robot.excel.workbook.PoiWorkbook
- All Implemented Interfaces:
- Editable
public class PoiWorkbook
- extends Object
- implements Editable
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 |
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)
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.