com.myjeeva.poi
Class ExcelXSSFRowCallbackHandler
java.lang.Object
com.myjeeva.poi.ExcelXSSFRowCallbackHandler
public class ExcelXSSFRowCallbackHandler
- extends Object
Excel Worksheet Handler for XML SAX parsing (.xlsx document model)
http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api
Inspired by Jeevanandam Madanagopal
https://github.com/jeevatkm/generic-repo/tree/master/excelReader
Usage: Provide a ExcelXSSFRowCallbackHandler.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.
- Author:
- https://github.com/DouglasCAyers
|
Method Summary |
void |
parse()
Parses the file, passing each row to the given callback. |
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
ExcelXSSFRowCallbackHandler
public ExcelXSSFRowCallbackHandler(OPCPackage opcPackage,
ExcelXSSFRowCallbackHandler.ExcelRowContentCallback rowCallback)
ExcelXSSFRowCallbackHandler
public ExcelXSSFRowCallbackHandler(InputStream inputStream,
ExcelXSSFRowCallbackHandler.ExcelRowContentCallback rowCallback)
throws InvalidFormatException,
IOException
- Throws:
InvalidFormatException
IOException
ExcelXSSFRowCallbackHandler
public ExcelXSSFRowCallbackHandler(File file,
ExcelXSSFRowCallbackHandler.ExcelRowContentCallback rowCallback)
throws InvalidFormatException
- Throws:
InvalidFormatException
ExcelXSSFRowCallbackHandler
public ExcelXSSFRowCallbackHandler(String filePath,
ExcelXSSFRowCallbackHandler.ExcelRowContentCallback rowCallback)
throws InvalidFormatException
- Throws:
InvalidFormatException
parse
public void parse()
throws Exception
- Parses the file, passing each row to the given callback.
At the end closes the opc package and underling input stream.
- Throws:
Exception