How to change formatter using apache-poi

Asked Jul 19 '19 at 07:27

Active Jul 19 '19 at 07:27

Viewed 127 times

I try to get data from .xlsx. The format of cell in excel is set: short date. Cell value: 12.01.2018. In console log I received: 1/12/19 but I need exactly the same value which is in cell. Here is my code:

DataFormatter formatter = new DataFormatter();
String val = formatter.formatCellValue(arkusz1.getRow(i).getCell(j));
tabArray[i][j] = val;
System.out.println("tabArray["+i+"]["+j+"] = " + val);```

edited Jul 19 '19 at 07:27

deHaar

17,687
10
38
51

asked Jul 19 '19 at 07:27

Mateusz Borek

why are you formatting value if you need exactly the same value which is in cell? – firegloves Jul 19 '19 at 07:31
I'm new in apache POI. Without this in console is: NullPointerExcepition. – Mateusz Borek Jul 19 '19 at 07:54
See https://stackoverflow.com/questions/53228302/poi-dataformatter-returns-2-digits-year-instead-of-4-digits-year-for-date-cells/53236531#53236531 – Axel Richter Jul 19 '19 at 07:59
1

You could try with Cell.getStringCellValue() or Cell.getDateCellValue() and then formatting it with java api – firegloves Jul 19 '19 at 08:06

How to change formatter using apache-poi

0 Answers0