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

Class StaxPoiWorkbook

java.lang.Object

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

All Implemented Interfaces:

AutoCloseable, 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

Modifier	Constructor	Description
protected	StaxPoiWorkbook()
	StaxPoiWorkbook(InputStream inputStream, String encoding)
	StaxPoiWorkbook(String filename, String encoding)

Method Summary

Modifier and Type	Method	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

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

Constructor Detail

StaxPoiWorkbook

protected StaxPoiWorkbook()

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 AutoCloseable

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