excel 2010 reader issue

Topics: Developer Forum
May 21, 2012 at 1:55 PM

PHP version:5.2.17
PHPexcel version: 1.7.7, 2012-05-19

Hi all

My client upgraded from office 2007 to 2010. It seems now that the code below no longer works for xlsx documents. I get no error messages, the scripts just stops. I can still load xls, csv etc... Is there something I can try or do? I can ask the client to save all his xlsx as xls but yea... not very user friendly.

Thank you

$objPHPExcel = $objReader->load($file); 

May 21, 2012 at 3:20 PM

have you checked your logs? maybe oom errors somewhere?

May 21, 2012 at 3:45 PM
Edited May 21, 2012 at 3:49 PM

yes, I just did

[21-May-2012 16:30:09] PHP Fatal error:  Class 'ZipArchive' not found in $$$$$$$$\phpExcel\Reader\Excel2007.php on line 497

php installation is running on windows server 2008 x64.

php_zip.dll is present in the \ext folder and is enabled in php.ini

=>phpinfo()

ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3

 

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value
May 21, 2012 at 3:53 PM

did you restart your webserver? Very nice that zlib is working, but please look for zip support in phpinfo ;)

 

for example:

zip

Zip enabled
Extension Version $Id: php_zip.c 321634 2012-01-01 13:15:04Z felipe $
Zip version 1.9.1
Libzip version 0.9.0 
May 21, 2012 at 3:57 PM
Edited May 21, 2012 at 5:27 PM

aha, okay

zip isn't showing in phpinfo()

problem? yeah...

i was thinking of upgrading my php version?

edit//could it be that php_zip.dll is not compatible with x64 platform? Anyway, there is a problem with my php installation and not with phpExcel, thank you for the quick response!