 | | | Retrieving numeric value using apache poi | Retrieving numeric value using apache poi 2007-05-23 - By becomp_2002
Back
Hi,
When I read a numeric cell of my excel sheet using
apache poi, it returns wrong double value as described
below.
The cell has value = 27.99%
when I read this cell value using apache poi it gives
me 0.27990000000000004
for (short inxColumn = 0; inxColumn <
getColumnCount(); inxColumn++) {
// Add each cell to the row
iCellType = row.getCell(inxColumn).getCellType();
System.out.println("iCellType = " + iCellType);
switch (iCellType) {
case HSSFCell.CELL_TYPE_NUMERIC :
double d =
row.getCell(inxColumn).getNumericCellValue();
System.out.println("row.getCell(inxColumn).getNumericCellValue()
= "+d);
break;
.
.
.
.
.
.
.
}
}
I need the value as 27.99
Can anyone please tell what could be wrong?
Thanks
Office firewalls, cyber cafes, college labs, don't allow you to download
CHAT? Click here: http://in.messenger.yahoo.com/webmessengerpromo.php
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: poi-user-unsubscribe@(protected)
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
|
|
|