Leading 0 issue

Hi, I am trying to add 0 in the sheet but its not getting add. $objPHPExcel->getActiveSheet()->setCellValueExplicit('A1', '0029', PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->getActiveSh...

Id #22455 | Release: None | Updated: Wed at 10:56 AM by Manish5041 | Created: Wed at 10:56 AM by Manish5041

PHPExcel 1.8 Settings.php 384. line Wrong local variable

The getLibXmlLoaderOptions() function is use $options variable. It is wrong because it is not defined. The class have a variable for this: self::$_libXmlLoaderOptions. I change my code and it is...

Id #22449 | Release: None | Updated: Jan 14 at 4:19 PM by MrGrassy | Created: Jan 14 at 4:19 PM by MrGrassy

Error While loading excel sheet

I am trying to load excel sheet (generated by other application) using phpexcel library, with following code $objReader = new PHPExcel_Reader_Excel2007(); $objReader->setReadDataOnly(true); $objPH...

Id #22414 | Release: None | Updated: Nov 21, 2016 at 5:25 PM by zohaibshahzad | Created: Nov 21, 2016 at 5:25 PM by zohaibshahzad

PHPExcel_Reader_Exception: ZipArchive library is not enabled

PhpExcel is throwing an exception: Type: PHPExcel_Reader_Exception Message: ZipArchive library is not enabled But i checked on the extensions and it is installed, what could be the problem.

Id #22413 | Release: None | Updated: Nov 20, 2016 at 4:36 PM by madonko88 | Created: Nov 20, 2016 at 4:36 PM by madonko88

PHP Excel 1.8.0 / PHP7 on Ubuntu 16.04 does not work

I am developing on Ubuntu 16.04 and using PHP7. The library seems to include fine as I do not get any issue reported require_once '../toolbox/PHPExcel-1.8.0/Classes/PHPExcel.php'; whenever I call...

Id #22376 | Release: None | Updated: Oct 24, 2016 at 2:57 PM by patrickvdbemt | Created: Oct 24, 2016 at 2:57 PM by patrickvdbemt

getCalculatedValue() doesn't work with readfilter

There seems to be a bug when using getCalculatedValue() with a PHPExcel_Reader_IReadFilter to read the file in chunks. I'm reading a file in a double loop with a chunk size of 10,000 - when it gets...

Id #22364 | Release: None | Updated: Oct 11, 2016 at 8:26 PM by neilwalden | Created: Oct 11, 2016 at 8:26 PM by neilwalden

Cann't save excel 2007 document with PHPExcel 1.8.0 at the combat host

Hello! By means of PHPExcel 1.8.0 I've developed the php code, which generates an excel file. This code works well at the localhost server but at the combat host it doesn't work. As I found out th...

Id #22361 | Release: None | Updated: Oct 10, 2016 at 8:09 AM by borro | Created: Oct 10, 2016 at 8:09 AM by borro

Error using PHP to read XLSX file created on Mac OS

This question relates to importing an XLSX file. If I create the file in Windows and import it using the PHPExcel library, it is working fine. But, if I create the file on a Mac, it throws an error...

Id #22360 | Release: None | Updated: Oct 10, 2016 at 6:35 AM by abhishek2016 | Created: Oct 10, 2016 at 6:35 AM by abhishek2016

Memory

Hello, I have a problem creating a report Excel gives me a memory error, and modify the php.ini and still the same, you could do?

Id #22359 | Release: None | Updated: Oct 8, 2016 at 4:47 PM by Gilbert280894 | Created: Oct 8, 2016 at 4:47 PM by Gilbert280894

Working fine in localhost but creating problem after uploading

I have written a php script to create a report in excel format its working very well in my localhost but its creating problem after uploading it to my site, no excel file is getting saved in my hos...

Id #22320 | Release: None | Updated: Aug 1, 2016 at 9:32 PM by umr55766 | Created: Aug 1, 2016 at 9:32 PM by umr55766