jxls can't read date column from excel using XML configuration

am using JXLS to read excel and having an issue while reading Date value.i have debugged code and see getT() value in getBaseCellType() as 'n' and then returning value as '0' (CELL_TYPE_NUMERIC).Also, able to see actual date value from excel but due to above cell type code is converting it to integer.Below is the sample XML used:\[code\]<workbook> <worksheet name="Sheet1"> <section startRow="0" endRow="0"/> <loop startRow="1" endRow="6" items="xxxxx" var="feed" varType="xxxxxx"> <section startRow="2" endRow="2"> <mapping row="2" col="15">feed.dobInfo.dob</mapping> <mapping row="2" col="22">feed.contactDtls.homePhone</mapping> <mapping row="2" col="23">feed.contactDtls.workPhone</mapping> <mapping row="2" col="24">feed.contactDtls.cellPhone</mapping> <mapping row="2" col="25">feed.occupation</mapping> </section> <loopbreakcondition> <rowcheck offset="0"> <cellcheck offset="0"/> </rowcheck> </loopbreakcondition> </loop> </worksheet></workbook>XSSFCell.class private int getBaseCellType(boolean blankCells) { switch (_cell.getT().intValue()) { case STCellType.INT_B: return CELL_TYPE_BOOLEAN; case STCellType.INT_N: if (!_cell.isSetV() && blankCells) { return CELL_TYPE_BLANK; } }\[/code\]
 
Back
Top