Reading date as string from excel using apache poi

Question

Reading date as string from excel using apache poi

I am trying to use the apache poi library to read excel. I want to convert a date field to a String value. So I used the following code:

if(cell.getCellType()==Cell.CELL_TYPE_NUMERIC){
    if(DateUtil.isCellDateFormatted(cell)){
       DataFormatter df = new DataFormatter();
       FormulaEvaluator fe = Workbook.getCreationHelper().createFormulaEvaluator();
       String str= formatter.formatCellValue(cell, fe);
       return str;
    }
}

I am getting Dates in a weird form which is <3/12 / [] 15>. The value of the cell id is 3/12/2015. Can anyone guide me on this.

+3

java apache-poi

codegeek 15 jul. 15 at 23:37

source to share

1 answer

andrewdleach · Answer 1 · 2015-07-16T01:46:33+0000

Instead of DateFormatter, just rewrite it like this:

if(cell.getCellType()==Cell.CELL_TYPE_NUMERIC){
    String date = cell.getDateCellValue();
   }
}

Reading date as string from excel using apache poi

More articles: