org.pentaho.di.core.spreadsheet
Interface KSheet

All Known Implementing Classes:

OdfSheet, PoiSheet, XLSSheet

public interface KSheet

The interface that is needed by ExcelInput to handle a single numeric data sheet in a workbook.

Author:

matt

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()

Method Detail

getRow

KCell[] getRow(int rownr)

Get one row of cells in the sheets

Parameters:

rownr - The row number to get

Returns:

the cells of the row

Throws:

ArrayIndexOutOfBoundsException - in case you try to read beyond the last row. (never returns null as such)

getName

String getName()

Returns:

The name of the cell

getRows

int getRows()

Returns:

The number of rows in the sheet

getCell

KCell getCell(int colnr,
              int rownr)

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

Parameters:

colnr - The column number

rownr - The row number

Returns:

The cell at the specified coordinates.