com.myjeeva.poi

Class ExcelWorkSheetRowCallbackHandler

java.lang.Object

com.myjeeva.poi.ExcelWorkSheetRowCallbackHandler

All Implemented Interfaces:

XSSFSheetXMLHandler.SheetContentsHandler

public class ExcelWorkSheetRowCallbackHandler
extends java.lang.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

Constructors

Constructor and Description
ExcelWorkSheetRowCallbackHandler(ExcelRowContentCallback rowCallbackHandler)

Method Summary

Methods

Modifier and Type	Method and Description
void	cell(java.lang.String cellReference, java.lang.String formattedValue)
void	endRow()
void	headerFooter(java.lang.String text, boolean isHeader, java.lang.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(java.lang.String cellReference,
        java.lang.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(java.lang.String text,
                boolean isHeader,
                java.lang.String tagName)

Specified by:

headerFooter in interface XSSFSheetXMLHandler.SheetContentsHandler

See Also:

XSSFSheetXMLHandler.SheetContentsHandler.headerFooter(java.lang.String, boolean, java.lang.String)