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

Class StaxPoiSheet

java.lang.Object

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

All Implemented Interfaces:

org.pentaho.di.core.spreadsheet.KSheet

public class StaxPoiSheet
extends Object
implements org.pentaho.di.core.spreadsheet.KSheet

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

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
void	close()
org.pentaho.di.core.spreadsheet.KCell	getCell(int colnr, int rownr)
String	getName()
org.pentaho.di.core.spreadsheet.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 org.pentaho.di.core.spreadsheet.KCell[] getRow(int rownr)

Specified by:

getRow in interface org.pentaho.di.core.spreadsheet.KSheet

getName

public String getName()

Specified by:

getName in interface org.pentaho.di.core.spreadsheet.KSheet

getRows

public int getRows()

Specified by:

getRows in interface org.pentaho.di.core.spreadsheet.KSheet

getCell

public org.pentaho.di.core.spreadsheet.KCell getCell(int colnr,
                                                     int rownr)

Specified by:

getCell in interface org.pentaho.di.core.spreadsheet.KSheet

isDateCell

protected boolean isDateCell(String cellStyle)

close

public void close()
           throws IOException,
                  XMLStreamException

Throws:

IOException

XMLStreamException