idare.imagenode.internal.DataSetReaders.POIReader

Class POIWorkBook

java.lang.Object

idare.imagenode.internal.DataSetReaders.POIReader.POIWorkBook

All Implemented Interfaces:

IDAREWorkbook

public class POIWorkBook
extends Object
implements IDAREWorkbook

Constructor Summary

Constructors

Constructor and Description
POIWorkBook(org.apache.poi.ss.usermodel.Workbook wb)

Method Summary

Modifier and Type	Method and Description
int	getNumberOfSheets() Get the number of individual data sheets present in this workbook
IDARESheet	getSheet(String arg0) Get the sheet with the specified name
IDARESheet	getSheetAt(int arg0) Get the Sheet at the requested position, or null if it does not exist-
int	getSheetIndex(IDARESheet arg0) Get the index of the provided IDARESheet.
int	getSheetIndex(String arg0) Get the 0-based index of a sheet with the provided name
String	getSheetName(int arg0) Get the name of the sheet at the provided position

Methods inherited from class java.lang.Object

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

Constructor Detail

POIWorkBook

public POIWorkBook(org.apache.poi.ss.usermodel.Workbook wb)

Method Detail

getNumberOfSheets

public int getNumberOfSheets()

Description copied from interface: IDAREWorkbook

Get the number of individual data sheets present in this workbook

Specified by:

getNumberOfSheets in interface IDAREWorkbook

Returns:

the number of non null sheets in this Workbook

getSheet

public IDARESheet getSheet(String arg0)

Description copied from interface: IDAREWorkbook

Get the sheet with the specified name

Specified by:

getSheet in interface IDAREWorkbook

Parameters:

arg0 - the name of the requested sheet

Returns:

the requested IDARESheet, or null if it does not exist.

getSheetAt

public IDARESheet getSheetAt(int arg0)

Description copied from interface: IDAREWorkbook

Get the Sheet at the requested position, or null if it does not exist-

Specified by:

getSheetAt in interface IDAREWorkbook

Parameters:

arg0 - the 0-based position of the Sheet.

Returns:

the sheet at the requested position

getSheetIndex

public int getSheetIndex(String arg0)

Description copied from interface: IDAREWorkbook

Get the 0-based index of a sheet with the provided name

Specified by:

getSheetIndex in interface IDAREWorkbook

Parameters:

arg0 - the name of the IDARESheet

Returns:

the index of the Sheet with the requested name, no two sheets are allowed to have the same name.

getSheetIndex

public int getSheetIndex(IDARESheet arg0)

Description copied from interface: IDAREWorkbook

Get the index of the provided IDARESheet.

Specified by:

getSheetIndex in interface IDAREWorkbook

Parameters:

arg0 - the Sheet for which to obtain the index.

Returns:

the index of the provided sheet.

getSheetName

public String getSheetName(int arg0)

Description copied from interface: IDAREWorkbook

Get the name of the sheet at the provided position

Specified by:

getSheetName in interface IDAREWorkbook

Parameters:

arg0 - the position of the sheet for which to obtain the name

Returns:

the name of the IDARESheet, or null if the position does not contain a sheet.