How to read the visible data of the cell, not the underlying formula?

Topics: Developer Forum, Project Management Forum, User Forum
Jul 25, 2011 at 1:46 PM

Hi All,

I want to know how to read the visible/calculated contents of the cells of an Excel Sheet & not the underlying formula.
For example:- if a cell contains sum(a1,a5) which equals say 123, then it shud read 123, not sum(a1,a5). Similarly for time, it shud read the time as it is, n not the referential value in ratio of 24:00:00...

Please help me out!!!

Viral Jain

Jul 28, 2011 at 11:48 AM

Use something like that :

$objPHPExcel->getActiveSheet()->getCell('B8')->getCalculatedValue();