net.objectlab.kit.util.excel

Class ExcelSheet

java.lang.Object

net.objectlab.kit.util.excel.ExcelSheet

public class ExcelSheet
extends Object

Constructor Summary

Constructors

Constructor and Description
ExcelSheet(org.apache.poi.xssf.streaming.SXSSFSheet sheet, ExcelWorkbook book)
ExcelSheet(org.apache.poi.xssf.usermodel.XSSFSheet sheet, ExcelWorkbook book)

Method Summary

Modifier and Type	Method and Description
ExcelSheet	autoSizeColumn(int startCol, int endCol)
ExcelSheet	mergeRegion(int startRow, int endRow, int startCol, int endCol)
ExcelRow	newRow()
ExcelRow	newRow(int rowIdx)
ExcelSheet	newSheet(String title)
org.apache.poi.ss.usermodel.Sheet	poiSheet()
org.apache.poi.ss.usermodel.Workbook	poiWorkbook()
int	rowIndex()
ExcelSheet	save(String fileName)
org.apache.poi.ss.usermodel.Sheet	sheet()
ExcelSheet	skipRow()
ExcelSheet	tabColour(org.apache.poi.ss.usermodel.IndexedColors colour)
ExcelWorkbook	workbook()

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelSheet

public ExcelSheet(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                  ExcelWorkbook book)

ExcelSheet

public ExcelSheet(org.apache.poi.xssf.streaming.SXSSFSheet sheet,
                  ExcelWorkbook book)

Method Detail

newRow

public ExcelRow newRow()

newRow

public ExcelRow newRow(int rowIdx)

sheet

public org.apache.poi.ss.usermodel.Sheet sheet()

poiWorkbook

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

skipRow

public ExcelSheet skipRow()

rowIndex

public int rowIndex()

newSheet

public ExcelSheet newSheet(String title)

autoSizeColumn

public ExcelSheet autoSizeColumn(int startCol,
                                 int endCol)

mergeRegion

public ExcelSheet mergeRegion(int startRow,
                              int endRow,
                              int startCol,
                              int endCol)

tabColour

public ExcelSheet tabColour(org.apache.poi.ss.usermodel.IndexedColors colour)

workbook

public ExcelWorkbook workbook()

save

public ExcelSheet save(String fileName)
                throws IOException

Throws:

IOException

poiSheet

public org.apache.poi.ss.usermodel.Sheet poiSheet()