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

Class StaxPoiWorkbook

java.lang.Object

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

All Implemented Interfaces:

org.pentaho.di.core.spreadsheet.KWorkbook

public class StaxPoiWorkbook
extends Object
implements org.pentaho.di.core.spreadsheet.KWorkbook

Streaming reader for XLSX files.
Does not open XLS.

Constructor Summary

Constructors

Constructor and Description
StaxPoiWorkbook(InputStream inputStream, String encoding)
StaxPoiWorkbook(String filename, String encoding)

Method Summary

Methods

Modifier and Type	Method and Description
void	close()
int	getNumberOfSheets()
org.pentaho.di.core.spreadsheet.KSheet	getSheet(int sheetNr)
org.pentaho.di.core.spreadsheet.KSheet	getSheet(String sheetName)
String	getSheetName(int sheetNr)
String[]	getSheetNames()

Methods inherited from class java.lang.Object

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

Constructor Detail

StaxPoiWorkbook

public StaxPoiWorkbook(String filename,
               String encoding)
                throws org.pentaho.di.core.exception.KettleException

Throws:

org.pentaho.di.core.exception.KettleException

StaxPoiWorkbook

public StaxPoiWorkbook(InputStream inputStream,
               String encoding)
                throws org.pentaho.di.core.exception.KettleException

Throws:

org.pentaho.di.core.exception.KettleException

Method Detail

getSheet

public org.pentaho.di.core.spreadsheet.KSheet getSheet(String sheetName)

Specified by:

getSheet in interface org.pentaho.di.core.spreadsheet.KWorkbook

getSheetNames

public String[] getSheetNames()

Specified by:

getSheetNames in interface org.pentaho.di.core.spreadsheet.KWorkbook

close

public void close()

Specified by:

close in interface org.pentaho.di.core.spreadsheet.KWorkbook

getNumberOfSheets

public int getNumberOfSheets()

Specified by:

getNumberOfSheets in interface org.pentaho.di.core.spreadsheet.KWorkbook

getSheet

public org.pentaho.di.core.spreadsheet.KSheet getSheet(int sheetNr)

Specified by:

getSheet in interface org.pentaho.di.core.spreadsheet.KWorkbook

getSheetName

public String getSheetName(int sheetNr)

Specified by:

getSheetName in interface org.pentaho.di.core.spreadsheet.KWorkbook