setReadDataOnly and excel 2010 file

Topics: User Forum
Aug 26, 2012 at 11:41 AM

Hi all,

it seems to me that setReadDataOnly for the reader is breaking everything up with native office 2010 excel file.

I tried with a really simple excel file, reader on it, if i set the ReadDataOnly to true, the file isn't parsed because of this error:

Notice: Undefined offset: -1 in [...]PHPExcel\PHPExcel.php on line 191 Fatal error: Call to a member function getHighestRow() on a non-object in [myscript]

Removing the "setReadDataOnly", the file is parsed correctly.

Saving the file in excel 2003 format and parsing it, is working correctly even with ReadDataOnly to true.

Is there any problem with excel 2010 files? (i was sure excel 2010 and 2007 were the same..)


Sep 1, 2012 at 6:19 PM

so is this a confirmed bug?

Sep 1, 2012 at 6:35 PM

No this isn't a confirmed bug, I haven't yet managed to recreate it.

Excel2007 and Excel2010 aren't identical, Excel2007 is Version 1 and Excel2010 is Version 3 of the ECMA standard; but Excel2010 files should not break the Excel2007 reader as they are an extension of the Version 1 standard.