ExcelWorkSheetRowCallbackHandler (Generic Excel File (XLSX) Reader 1.2 API)

Package

Class

Use

Tree

Deprecated

Index

Help

Generic Excel File (XLSX) Reader

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.myjeeva.poi
Class ExcelWorkSheetRowCallbackHandler

java.lang.Object
  com.myjeeva.poi.ExcelWorkSheetRowCallbackHandler

All Implemented Interfaces:: XSSFSheetXMLHandler.SheetContentsHandler

public class ExcelWorkSheetRowCallbackHandler
extends Object
implements XSSFSheetXMLHandler.SheetContentsHandler
extends Object
implements XSSFSheetXMLHandler.SheetContentsHandler

Excel Worksheet Handler for XML SAX parsing (.xlsx document model) http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api

Inspired by Jeevanandam M. https://github.com/jeevatkm/excelReader

Usage: Provide a ExcelRowContentCallback callback that will be provided a map representing a row of data from the file. The keys will be the column headers and values the row data. Your callback class encapsulates any business logic for processing the string data into dates, numbers, etc to allow full customization of the parsing and processing logic.

Since:: v1.1
Author:: https://github.com/DouglasCAyers, Jeevanandam M.

Constructor Summary
`ExcelWorkSheetRowCallbackHandler(ExcelRowContentCallback rowCallbackHandler)`

Method Summary
`void`	`cell(String cellReference, String formattedValue)`
`void`	`endRow()`
`void`	`headerFooter(String text, boolean isHeader, String tagName)`
`void`	`startRow(int rowNum)`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Constructor Detail

ExcelWorkSheetRowCallbackHandler

public ExcelWorkSheetRowCallbackHandler(ExcelRowContentCallback rowCallbackHandler)

Method Detail

startRow

public void startRow(int rowNum)

Specified by:: startRow in interface XSSFSheetXMLHandler.SheetContentsHandler

See Also:: XSSFSheetXMLHandler.SheetContentsHandler.startRow(int)

cell

public void cell(String cellReference,
                 String formattedValue)

Specified by:: cell in interface XSSFSheetXMLHandler.SheetContentsHandler

See Also:: XSSFSheetXMLHandler.SheetContentsHandler.cell(java.lang.String, java.lang.String)

endRow

public void endRow()

Specified by:: endRow in interface XSSFSheetXMLHandler.SheetContentsHandler

See Also:: XSSFSheetXMLHandler.SheetContentsHandler.endRow()

headerFooter

public void headerFooter(String text,
                         boolean isHeader,
                         String tagName)

Specified by:: headerFooter in interface XSSFSheetXMLHandler.SheetContentsHandler

See Also:: XSSFSheetXMLHandler.SheetContentsHandler.headerFooter(java.lang.String, boolean, java.lang.String)