Issue while reading percentage value from xlsx using apache poi

Asked Jan 06 '16 at 16:23

Active Jan 06 '16 at 16:23

Viewed 29 times

I am reading an xlsx file using apache poi jar through java.

The particular row of xlsx file reads as following on opening the xlsx file in MS-Excel:

When I try to read the highlighted value using poi, it gives me 0.1087091684032691

Both cell.toString() and cell.getNumericCellValue() are returning 0.1087091684032691 instead of 10.8709168403269%.

Kindly suggest.

asked Jan 06 '16 at 16:23

Sammidbest

1

Kindly suggest what? ;) Percentages are stored as fractions. Just multiply by 100 – Phil Anderson Jan 06 '16 at 16:26
Thanks Phil :) I was wondering if It is normal behavior to get a fraction value or not. – Sammidbest Jan 06 '16 at 16:38

0 Answers0