net.objectlab.kit.util.excel

Class ExcelCell

java.lang.Object

net.objectlab.kit.util.excel.ExcelCell

public class ExcelCell
extends Object

Constructor Summary

Constructors

Constructor and Description
ExcelCell(org.apache.poi.ss.usermodel.Cell cell, ExcelRow row)

Method Summary

Modifier and Type	Method and Description
ExcelCell	autoSizeColumn(int startCol, int endCol)
org.apache.poi.ss.usermodel.CellStyle	cloneStyle()
org.apache.poi.ss.usermodel.CellStyle	cloneStyle(int styleHashcode)
ExcelCell	comment(String commentText)
Optional<org.apache.poi.ss.usermodel.CellStyle>	findStyle(int styleHashcode)
ExcelCell	formula(String formula)
ExcelCell	link(String url, String label)
ExcelCell	newCell(boolean value)
ExcelCell	newCell(long value)
ExcelCell	newCell(Number value)
ExcelCell	newCell(String value)
ExcelCell	newCell(String url, String label) Add a hyperlink
ExcelCell	newCell(Temporal value)
ExcelCell	newCellFormula(String formula)
ExcelRow	newRow()
ExcelRow	newRow(int rowIdx)
ExcelSheet	newSheet(String title)
org.apache.poi.ss.usermodel.Cell	poiCell()
org.apache.poi.ss.usermodel.Row	poiRow()
org.apache.poi.ss.usermodel.Workbook	poiWorkbook()
ExcelRow	row()
int	rowIndex()
ExcelCell	save(String fileName)
ExcelCell	setStyle(org.apache.poi.ss.usermodel.CellStyle style)
ExcelRow	skipCol()
ExcelCell	style(ExcelStyle style)
ExcelCell	value(boolean value)
ExcelCell	value(long value)
ExcelCell	value(Number value)
ExcelCell	value(String value)
ExcelCell	value(Temporal value)
ExcelWorkbook	workbook()

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelCell

public ExcelCell(org.apache.poi.ss.usermodel.Cell cell,
                 ExcelRow row)

Method Detail

value

public ExcelCell value(String value)

value

public ExcelCell value(Temporal value)

row

public ExcelRow row()

rowIndex

public int rowIndex()

skipCol

public ExcelRow skipCol()

newCell

public ExcelCell newCell(String value)

newCell

public ExcelCell newCell(Temporal value)

newCellFormula

public ExcelCell newCellFormula(String formula)

newCell

public ExcelCell newCell(String url,
                         String label)

Add a hyperlink

Parameters:

url - URL

label - Label for the cell

Returns:

the cell

newCell

public ExcelCell newCell(boolean value)

newCell

public ExcelCell newCell(long value)

newCell

public ExcelCell newCell(Number value)

newRow

public ExcelRow newRow()

newSheet

public ExcelSheet newSheet(String title)

link

public ExcelCell link(String url,
                      String label)

value

public ExcelCell value(long value)

formula

public ExcelCell formula(String formula)

value

public ExcelCell value(Number value)

value

public ExcelCell value(boolean value)

cloneStyle

public org.apache.poi.ss.usermodel.CellStyle cloneStyle()

setStyle

public ExcelCell setStyle(org.apache.poi.ss.usermodel.CellStyle style)

style

public ExcelCell style(ExcelStyle style)

findStyle

public Optional<org.apache.poi.ss.usermodel.CellStyle> findStyle(int styleHashcode)

cloneStyle

public org.apache.poi.ss.usermodel.CellStyle cloneStyle(int styleHashcode)

newRow

public ExcelRow newRow(int rowIdx)

workbook

public ExcelWorkbook workbook()

save

public ExcelCell save(String fileName)
               throws IOException

Throws:

IOException

comment

public ExcelCell comment(String commentText)

autoSizeColumn

public ExcelCell autoSizeColumn(int startCol,
                                int endCol)

poiCell

public org.apache.poi.ss.usermodel.Cell poiCell()

poiRow

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

poiWorkbook

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