search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.19k forks source link

Help needed with generated corrupt excel file. #263

Closed ignace closed 10 years ago

ignace commented 10 years ago

I have a problem where PHPExcel generates corrupt excel files. I am assuming it's due to a wrong module or something? But I am at a loss to which one is faulty.

zip Zip => enabled Extension Version => $Id: d7bd5f49e62be1c7d06e510b3bf330b83fe65b28 $ Zip version => 1.11.0 Libzip version => 0.10.1

xml XML Support => active XML Namespace Support => active libxml2 Version => 2.8.0

gd GD Support => enabled GD Version => bundled (2.1.0 compatible) FreeType Support => enabled FreeType Linkage => with freetype FreeType Version => 2.4.9 T1Lib Support => enabled GIF Read Support => enabled GIF Create Support => enabled JPEG Support => enabled libJPEG Version => 8 PNG Support => enabled libPNG Version => 1.2.49 WBMP Support => enabled XPM Support => enabled libXpm Version => 30411 XBM Support => enabled

Directive => Local Value => Master Value gd.jpeg_ignore_warning => 0 => 0

php PHP 5.4.20-1~dotdeb.1 (cli) (built: Sep 21 2013 22:24:38) Copyright (c) 1997-2013 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies with Xdebug v2.2.3, Copyright (c) 2002-2013, by Derick Rethans

PHPExcel name : phpoffice/phpexcel descrip. : PHPExcel - OpenXML - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine keywords : php, excel, spreadsheet, xls, xlsx, OpenXML versions : dev-master, 1.7.9, 1.7.9-rc1, dev-develop_2.0.0, dev-develop_1.7.9, dev-develop, dev-HTMLReader, dev-cellRestructure, dev-calcEngine, dev-experimental type : library license : LGPL source : [git] https://github.com/PHPOffice/PHPExcel.git 7a7634fba664249a04fc771df677a9b9f755d7ec dist : [zip] https://api.github.com/repos/PHPOffice/PHPExcel/zipball/7a7634fba664249a04fc771df677a9b9f755d7ec 7a7634fba664249a04fc771df677a9b9f755d7ec names : phpoffice/phpexcel

autoload psr-0 PHPExcel => Classes/

requires php >=5.2.0 ext-xml *

code used

$excelObject = new PHPExcel();
PHPExcel_IOFactory::createWriter($excelObject, 'Excel2007')->save($filepath);

I assume the above code would output an empty excel file, but instead it is corrupt.

When I use hexedit viewer (first 8 bytes): 50 4B 03 04 14 00 00 00

ignace commented 10 years ago

Nevermind. Apparently it's a problem with OpenOffice.