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)

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);

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

 

P

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.

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