Problem with ->getSheet()->toArray()

Topics: Developer Forum
Mar 26, 2012 at 12:22 PM
Edited Mar 26, 2012 at 12:29 PM

Hi all,

I need to create and save xls(x) files and render them in a js API. Creation is fine, opening causes some problems.

If there is a graph (generated through the API) PHPExcel throws 

Exception: Worksheet!A21 -> Formula Error: An unexpected error occured in /PHPExcel/Cell.php on line 288

If there is no graph (only 6 cells, one of which is a SUM of the others), the results are quite unexpected.

var_dump($objPHPExcel->getSheet()->toArray());

Returns an array with length of 25 with unintelligible strings and nulls

More code, the xlsx file and screenshots of the errors

 

I'm using:

  • PHPExcel version 1.7.6
  • PHP Version 5.1.6 under Linux

 

Thank you in advance