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

Class PoiWorkbook

java.lang.Object

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

All Implemented Interfaces:

AutoCloseable, org.pentaho.di.core.spreadsheet.KWorkbook

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

Constructor Summary

Constructors

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

Method Summary

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

PoiWorkbook

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

Throws:

org.pentaho.di.core.exception.KettleException

PoiWorkbook

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

Throws:

org.pentaho.di.core.exception.KettleException

PoiWorkbook

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

Throws:

org.pentaho.di.core.exception.KettleException

Method Detail

close

public void close()

Specified by:

close in interface AutoCloseable

Specified by:

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

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

getFilename

public String getFilename()

getEncoding

public String getEncoding()

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