poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yogita <yogita_kashi...@ml.com>
Subject Reading value from formula cell
Date Wed, 12 Jan 2005 20:02:00 GMT
Hi,

I am facing difficulties while reading formula cell values with POI version 
2.5.

I have created formula cell as follows:
			cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
			cell.setCellFormula("SUM(D8..F8)");

And I am reading it as follow:
   double formulaCellValue = row.getCell((short) 7).getNumericCellValue();

When read this way(using getNumericCellValue()), I am always getting the value 
of 0.0. 

Any quick help in this regard would be highly appriciated.

Thanks in advance,
Yogita.


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message