org.pentaho.di.trans.steps.excelinput.poi

Class PoiWorkbook

java.lang.Object

org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook

All Implemented Interfaces:

AutoCloseable, KWorkbook

public class PoiWorkbook
extends Object
implements KWorkbook

Constructor Summary

Constructors

Constructor and Description
PoiWorkbook(InputStream inputStream, String encoding)
PoiWorkbook(String filename, String encoding)
PoiWorkbook(String filename, String encoding, String password)

Method Summary

Modifier and Type	Method and Description
void	close()
String	getEncoding()
String	getFilename()
int	getNumberOfSheets()
KSheet	getSheet(int sheetNr)
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

PoiWorkbook

public PoiWorkbook(String filename,
                   String encoding)
            throws KettleException

Throws:

KettleException

PoiWorkbook

public PoiWorkbook(String filename,
                   String encoding,
                   String password)
            throws KettleException

Throws:

KettleException

PoiWorkbook

public PoiWorkbook(InputStream inputStream,
                   String encoding)
            throws KettleException

Throws:

KettleException

Method Detail

close

public void close()

Specified by:

close in interface AutoCloseable

Specified by:

close in interface KWorkbook

getSheet

public KSheet getSheet(String sheetName)

Specified by:

getSheet in interface KWorkbook

getSheetNames

public String[] getSheetNames()

Specified by:

getSheetNames in interface KWorkbook

getFilename

public String getFilename()

getEncoding

public String getEncoding()

getNumberOfSheets

public int getNumberOfSheets()

Specified by:

getNumberOfSheets in interface KWorkbook

getSheet

public KSheet getSheet(int sheetNr)

Specified by:

getSheet in interface KWorkbook

getSheetName

public String getSheetName(int sheetNr)

Specified by:

getSheetName in interface KWorkbook