net.objectlab.kit.util.excel

Class ExcelRow

java.lang.Object

net.objectlab.kit.util.excel.ExcelRow

public class ExcelRow
extends Object

Constructor Summary

Constructors

Constructor and Description
ExcelRow(org.apache.poi.ss.usermodel.Row row, ExcelSheet sheet)

Method Summary

Modifier and Type	Method and Description
ExcelRow	autoSizeColumn(int startCol, int endCol)
int	colIndex()
ExcelCell	newCell()
ExcelCell	newCell(long value)
ExcelCell	newCell(Number value)
ExcelCell	newCell(String value)
ExcelCell	newCell(Temporal value)
ExcelCell	newCellFormula(String formula)
ExcelRow	newRow()
ExcelRow	newRow(int rowIdx)
ExcelSheet	newSheet(String title)
org.apache.poi.ss.usermodel.Row	poiRow()
org.apache.poi.ss.usermodel.Workbook	poiWorkbook()
int	rowIndex()
ExcelRow	save(String fileName)
ExcelSheet	sheet()
ExcelRow	skipCol()
ExcelRow	style(ExcelStyle style)
ExcelWorkbook	workbook()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExcelRow

public ExcelRow(org.apache.poi.ss.usermodel.Row row,
                ExcelSheet sheet)

Method Detail

newCell

public ExcelCell newCell()

newCell

public ExcelCell newCell(String value)

newCell

public ExcelCell newCell(Temporal value)

newCellFormula

public ExcelCell newCellFormula(String formula)

newCell

public ExcelCell newCell(long value)

newCell

public ExcelCell newCell(Number value)

skipCol

public ExcelRow skipCol()

newRow

public ExcelRow newRow()

newRow

public ExcelRow newRow(int rowIdx)

newSheet

public ExcelSheet newSheet(String title)

poiRow

public org.apache.poi.ss.usermodel.Row poiRow()

rowIndex

public int rowIndex()

colIndex

public int colIndex()

sheet

public ExcelSheet sheet()

workbook

public ExcelWorkbook workbook()

poiWorkbook

public org.apache.poi.ss.usermodel.Workbook poiWorkbook()

save

public ExcelRow save(String fileName)
              throws IOException

Throws:

IOException

autoSizeColumn

public ExcelRow autoSizeColumn(int startCol,
                               int endCol)

style

public ExcelRow style(ExcelStyle style)