parsing cells like =ROUND(SUM(N4:N5),5)?

Topics: Developer Forum
Oct 11, 2010 at 8:28 PM

Say I have a cell whose value is =ROUND(SUM(N4:N5),5).  Is there a way to parse that into its actual value with PHPExcel?

Coordinator
Oct 11, 2010 at 8:44 PM
Edited Oct 11, 2010 at 8:44 PM

Yes! If you read the manual or look at the examples, you'll find:

$result = $objPHPExcel->getActiveSheet()->getCell($cellID)->getCalculatedValue();