Generic Excel File(XLSX) Reader
C E G H I M P S

C

cell(String, String) - Method in class com.myjeeva.poi.ExcelWorkSheetHandler
 
com.myjeeva.poi - package com.myjeeva.poi
 
com.myjeeva.poi.demo - package com.myjeeva.poi.demo
 
com.myjeeva.poi.demo.vo - package com.myjeeva.poi.demo.vo
 

E

endRow() - Method in class com.myjeeva.poi.ExcelWorkSheetHandler
 
Excel2JavaDemo - Class in com.myjeeva.poi.demo
Demonstration of Generic Excel File (XLSX) Reading using Apache POI
Excel2JavaDemo() - Constructor for class com.myjeeva.poi.demo.Excel2JavaDemo
 
ExcelReader - Class in com.myjeeva.poi
 
ExcelReader(OPCPackage, XSSFSheetXMLHandler.SheetContentsHandler) - Constructor for class com.myjeeva.poi.ExcelReader
Constructor: Microsoft Excel File Reader (XLSX)
ExcelRowCallbackDemo - Class in com.myjeeva.poi.demo
Excel Worksheet Handler for XML SAX parsing (.xlsx document model) http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api
ExcelRowCallbackDemo() - Constructor for class com.myjeeva.poi.demo.ExcelRowCallbackDemo
 
ExcelWorkSheetHandler<T> - Class in com.myjeeva.poi
Generic Excel WorkSheet handler
ExcelWorkSheetHandler(Class<T>, Map<String, String>) - Constructor for class com.myjeeva.poi.ExcelWorkSheetHandler
Constructor

For Example: Reading rows (zero based) starting from Zero
ExcelWorkSheetHandler<PersonVO> workSheetHandler = new ExcelWorkSheetHandler<PersonVO>(PersonVO.class, cellMapping);
ExcelWorkSheetHandler(Class<T>, Map<String, String>, int) - Constructor for class com.myjeeva.poi.ExcelWorkSheetHandler
Constructor

For Example: Reading rows (zero based) starting from Row 11
ExcelWorkSheetHandler<PersonVO> workSheetHandler = new ExcelWorkSheetHandler<PersonVO>(PersonVO.class, cellMapping, 10);
ExcelXSSFRowCallbackHandler - Class in com.myjeeva.poi
Excel Worksheet Handler for XML SAX parsing (.xlsx document model) http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api
ExcelXSSFRowCallbackHandler(OPCPackage, ExcelXSSFRowCallbackHandler.ExcelRowContentCallback) - Constructor for class com.myjeeva.poi.ExcelXSSFRowCallbackHandler
 
ExcelXSSFRowCallbackHandler(InputStream, ExcelXSSFRowCallbackHandler.ExcelRowContentCallback) - Constructor for class com.myjeeva.poi.ExcelXSSFRowCallbackHandler
 
ExcelXSSFRowCallbackHandler(File, ExcelXSSFRowCallbackHandler.ExcelRowContentCallback) - Constructor for class com.myjeeva.poi.ExcelXSSFRowCallbackHandler
 
ExcelXSSFRowCallbackHandler(String, ExcelXSSFRowCallbackHandler.ExcelRowContentCallback) - Constructor for class com.myjeeva.poi.ExcelXSSFRowCallbackHandler
 
ExcelXSSFRowCallbackHandler.ExcelRowContentCallback - Interface in com.myjeeva.poi
Callback for processing a single row from excel file.

G

getDob() - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
getEmailId() - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
getHeight() - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
getName() - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
getPersonId() - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
getSalary() - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
getValueList() - Method in class com.myjeeva.poi.ExcelWorkSheetHandler
Returns Value List (List<T>) read from Excel Workbook, Row represents one Object in a List.

H

headerFooter(String, boolean, String) - Method in class com.myjeeva.poi.ExcelWorkSheetHandler
Currently not considered for implementation

I

isVerifiyHeader() - Method in class com.myjeeva.poi.ExcelWorkSheetHandler
Returns Excel Header check state, default it is enabled

M

main(String[]) - Static method in class com.myjeeva.poi.demo.Excel2JavaDemo
 
main(String[]) - Static method in class com.myjeeva.poi.demo.ExcelRowCallbackDemo
 

P

parse() - Method in class com.myjeeva.poi.ExcelXSSFRowCallbackHandler
Parses the file, passing each row to the given callback.
PersonVO - Class in com.myjeeva.poi.demo.vo
Sample ValueObject for Reading a Value from Excel File (XLSX)
PersonVO() - Constructor for class com.myjeeva.poi.demo.vo.PersonVO
 
process() - Method in class com.myjeeva.poi.ExcelReader
Processing all the WorkSheet from XLSX Workbook.
process(int) - Method in class com.myjeeva.poi.ExcelReader
Processing of particular WorkSheet (zero based) from XLSX Workbook.
process(Map<String, String>, int) - Method in interface com.myjeeva.poi.ExcelXSSFRowCallbackHandler.ExcelRowContentCallback
 

S

setDob(String) - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
setEmailId(String) - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
setHeight(String) - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
setName(String) - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
setPersonId(String) - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
setSalary(String) - Method in class com.myjeeva.poi.demo.vo.PersonVO
 
setVerifiyHeader(boolean) - Method in class com.myjeeva.poi.ExcelWorkSheetHandler
To set the Excel Header check state, default it is enabled
startRow(int) - Method in class com.myjeeva.poi.ExcelWorkSheetHandler
 

C E G H I M P S
Generic Excel File(XLSX) Reader

Copyright © myjeeva.com, All rights reserved.

The copyright of the pages and contents on this website is with myjeeva.com and the content is licensed under Creative Commons Attribution-Share Alike 3.0 Unported License. Libraries and code snippets on myjeeva.com has license information.