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

Topics: Developer Forum
Mar 26, 2012 at 11:22 AM
Edited Mar 26, 2012 at 11:29 AM

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.


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