Problem with different version of excel... (2010 and below != excel 365)

Hello guys, I currently am experiencing 2 problems in regards with excel output. I don't know if it's a bug or not, if it's excel's fault or the phpexcel itself. General info (Applied to both pro...

Id #22501 | Release: None | Updated: Mar 10 at 3:48 AM by EnvY_28 | Created: Mar 10 at 3:47 AM by EnvY_28

Creating extra row without data in excel using PHPEXCEL in codeigniter

I'm creating an excel file using PHPEXCEL library in codeigniter. Actually i'm taking the data from one excel file and copying the data from loaded file to new file. Finally a new excel is creatin...

Id #22500 | Release: None | Updated: Mar 8 at 4:42 AM by srinuyagnam | Created: Mar 8 at 2:00 AM by srinuyagnam

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: Jan 18 at 9:56 AM by Manish5041 | Created: Jan 18 at 9: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 3:19 PM by MrGrassy | Created: Jan 14 at 3: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 4:25 PM by zohaibshahzad | Created: Nov 21, 2016 at 4: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 3:36 PM by madonko88 | Created: Nov 20, 2016 at 3: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 1:57 PM by patrickvdbemt | Created: Oct 24, 2016 at 1: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 7:26 PM by neilwalden | Created: Oct 11, 2016 at 7: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 7:09 AM by borro | Created: Oct 10, 2016 at 7: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 5:35 AM by abhishek2016 | Created: Oct 10, 2016 at 5:35 AM by abhishek2016