net.objectlab.kit.util.excel

Class Excel

java.lang.Object

net.objectlab.kit.util.excel.Excel

public class Excel
extends Object

Constructor Summary

Constructors

Constructor and Description
Excel(InputStream in)

Method Summary

Modifier and Type	Method and Description
org.apache.poi.ss.usermodel.Cell	cellAt(String cellAddr)
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
Object[][]	readBlock(String range, Class<?>... columnTypes)
<E> List<E>	readColumn(String rangeOrStartAddress, Class<E> type)
<E> E	readValueAt(String cellAddress, Class<E> type)

Methods inherited from class java.lang.Object

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

Constructor Detail

Excel

public Excel(InputStream in)

Method Detail

readValueAt

public <E> E readValueAt(String cellAddress,
                         Class<E> type)

readColumn

public <E> List<E> readColumn(String rangeOrStartAddress,
                              Class<E> type)

cellAt

public org.apache.poi.ss.usermodel.Cell cellAt(String cellAddr)

readBlock

public Object[][] readBlock(String range,
                            Class<?>... columnTypes)

Parameters:

range - either the range of the entire block to be read, or just the top row of the cells, in which case the method will stop when the first empty cell is reached in the first column

columnTypes - An array of data types expected at each column. If this array is shorter than the number of column, then the last data type is used until the end. So if only one value is given, then that is used for the entire block.

getWorkbook

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