Well, there are really two answers to this question that depend upon whether you want to get at the formula or at the result of the formula. To recover the formula from the cell, all you need to to is test it's type, and if it is a formula cell, then simply call the getCellForumla() method on the cell reference. If instead you want to get at the result of the forumla, then it may be best to evaluate the cell and then recover the result from it. The best guide to this process can be found by reading this page - http://poi.apache.org/spreadsheet/eval.html
Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-get-formula-cell-value-using-apache-poi-3-5-tp3266873p3269321.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
