com.myjeeva.poi
Class ExcelReader

java.lang.Object
  com.myjeeva.poi.ExcelReader

public class ExcelReader
extends Object

Constructor Summary

ExcelReader(OPCPackage pkg, XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler)
Constructor: Microsoft Excel File Reader (XLSX)

Method Summary

void	process() Processing all the WorkSheet from XLSX Workbook.
void	process(int sheetNumber) Processing of particular WorkSheet (zero based) from XLSX Workbook.

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelReader

public ExcelReader(OPCPackage pkg,
                   XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler)

Constructor: Microsoft Excel File Reader (XLSX)

Parameters:

pkg - a OPCPackage object - The package to process XLSX

sheetContentsHandler - a XSSFSheetXMLHandler.SheetContentsHandler object - WorkSheet contents handler

Method Detail

process

public void process()
             throws RuntimeException

Processing all the WorkSheet from XLSX Workbook.

For Example:
ExcelReader excelReader = new ExcelReader(pkg, workSheetHandler); excelReader.process();

Throws:

RuntimeException

process

public void process(int sheetNumber)
             throws RuntimeException

Processing of particular WorkSheet (zero based) from XLSX Workbook.

For Example:
ExcelReader excelReader = new ExcelReader(pkg, workSheetHandler); excelReader.process(2);

Parameters:

sheetNumber - a int object

Throws:

RuntimeException