org.pentaho.di.trans.steps.excelinput.staxpoi

Class StaxPoiSheet

java.lang.Object

org.pentaho.di.trans.steps.excelinput.staxpoi.StaxPoiSheet

All Implemented Interfaces:

KSheet

public class StaxPoiSheet
extends Object
implements KSheet

Streaming reader for XLSX sheets.
Rows should only be accessed sequentially: random access will severely impact performance.

Constructor Summary

Constructors

Constructor and Description
StaxPoiSheet(org.apache.poi.xssf.eventusermodel.XSSFReader reader, String sheetName, String sheetID)

Method Summary

Modifier and Type	Method and Description
void	close()
KCell	getCell(int colnr, int rownr)
String	getName()
KCell[]	getRow(int rownr)
int	getRows()
protected boolean	isDateCell(String cellStyle)

Methods inherited from class java.lang.Object

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

Constructor Detail

StaxPoiSheet

public StaxPoiSheet(org.apache.poi.xssf.eventusermodel.XSSFReader reader,
                    String sheetName,
                    String sheetID)
             throws org.apache.poi.openxml4j.exceptions.InvalidFormatException,
                    IOException,
                    XMLStreamException

Throws:

org.apache.poi.openxml4j.exceptions.InvalidFormatException

IOException

XMLStreamException

Method Detail

getRow

public KCell[] getRow(int rownr)

Specified by:

getRow in interface KSheet

getName

public String getName()

Specified by:

getName in interface KSheet

getRows

public int getRows()

Specified by:

getRows in interface KSheet

getCell

public KCell getCell(int colnr,
                     int rownr)

Specified by:

getCell in interface KSheet

isDateCell

protected boolean isDateCell(String cellStyle)

close

public void close()
           throws IOException,
                  XMLStreamException

Throws:

IOException

XMLStreamException