getCalculatedValue and another excel file

Topics: Developer Forum, Project Management Forum, User Forum
Jun 8, 2011 at 8:33 PM
Edited Jun 8, 2011 at 8:34 PM


To begin, sorry for me english but i'm french :)

I'm a tring to calculate a cell who is linked with an other excel file, but my code doesn't work...
Look :

    $file = 'ok.xls';
    $excel_reader = new PHPExcel_Reader_Excel5();
    $classeur = $excel_reader->load($file) ;
    $sheet = $classeur->getSheet(0);
    echo $sheet->getCellByColumnAndRow(0, 1)->getCalculatedValue();

My ok.xls, contain on A1 :
='Macintosh HD:Users:pierre:www:[test.xls]Feuil1'!A1

And my test.xls contain on A1 : "test"

When i open manually ok.xls, the cell A1 shows "test" but with EXCEL PHP, i obtain : #REF!

How to get the good value ?