org.pentaho.di.trans.steps.excelinput.poi
Class PoiSheet

java.lang.Object
  org.pentaho.di.trans.steps.excelinput.poi.PoiSheet

All Implemented Interfaces:

KSheet

public class PoiSheet
extends Object
implements KSheet

Constructor Summary

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

Method Summary

KCell	getCell(int colnr, int rownr) Get a cell in the sheet by specification of its coordinates.
String	getName()
KCell[]	getRow(int rownr) Get one row of cells in the sheets
int	getRows()

Methods inherited from class java.lang.Object

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

Constructor Detail

PoiSheet

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

Method Detail

getName

public String getName()

Specified by:

getName in interface KSheet

Returns:

The name of the cell

getRow

public KCell[] getRow(int rownr)

Description copied from interface: KSheet

Get one row of cells in the sheets

Specified by:

getRow in interface KSheet

Parameters:

rownr - The row number to get

Returns:

the cells of the row

getRows

public int getRows()

Specified by:

getRows in interface KSheet

Returns:

The number of rows in the sheet

getCell

public KCell getCell(int colnr,
                     int rownr)

Description copied from interface: KSheet

Get a cell in the sheet by specification of its coordinates.

Specified by:

getCell in interface KSheet

Parameters:

colnr - The column number

rownr - The row number

Returns:

The cell at the specified coordinates.