Writing Large Excel File

It appears to me that one of the major drawbacks to PHPExcel is the inability to write large files. We needed an Excel writer for PHP that could handle writing massive files. I've attempted to use ...

Id #19697 | Release: None | Updated: May 10 at 3:26 PM by teynon | Created: May 10 at 3:26 PM by teynon

I am not able to generate a pdf file

I have used following code to generate a PDF but PDF is not getting generated. private function renderPdf($filename) { header('Content-Type: application/vnd.pdf'); header('Content-Disposi...

Id #19685 | Release: None | Updated: May 9 at 1:44 PM by MarkBaker | Created: May 9 at 12:56 PM by PrachiN

SUMIF formula ranges are not updating after insertNewRowBefore

SUMIF formula ranges are not updating after insertNewRowBefore. Is that normal activity? Thanks, Gannon $objPHPExcel->getActiveSheet()->setCellValue('C25', 'AGS141'); $objPHPExcel->getActiveShe...

Id #19681 | Release: None | Updated: Thu at 1:31 AM by ggoo888 | Created: May 8 at 2:34 AM by ggoo888

.XLSX download

As of php 5.3.0 php_zip.dll no longer exists. ZipArchive is built-in. Save file to PHP://output does not work any longer for Excel2007 format using the php ziparchive. Only the PHPExcel built-in zi...

Id #19664 | Release: None | Updated: Tue at 7:23 AM by mrbladergroen | Created: May 3 at 8:35 AM by mrbladergroen

Unable to read Excel file

I've been trying everything I know to get PHPExcel to read this file, but nothing works. identify() can't event tell me what it is. But it's not a CSV or XML file and opens perfectly in my version ...

Id #19656 | Release: None | Updated: May 1 at 10:20 PM by MarkBaker | Created: May 1 at 5:32 PM by pisaacs

Reading large file with catch

Hi, I have about 100,000 row in 15 columns. I am using catch because of limited memory. the program can read 100,000 row without any problem but when it writes back to excel file, I got the error...

Id #19644 | Release: None | Updated: Apr 25 at 6:47 PM by atkins | Created: Apr 25 at 6:01 PM by atkins

Error in reading password protected exel file. Is there any way to read the password protected exel sheet using password.

I have a password protected exel file. The password is known to me. But I didn't find a way to open the password protected exel file using password. Is there any way to read the password protected ...

Id #19631 | Release: None | Updated: Apr 23 at 6:13 AM by sadeep | Created: Apr 23 at 6:13 AM by sadeep

How can sort a column after I read the excel file into memory?

How can I sort a column after I read an excel file into memory? Also, after I read two files into memory, how can I compare two files and save only the different from both file? PhpEXcel version ...

Id #19630 | Release: None | Updated: Apr 22 at 7:35 PM by atkins | Created: Apr 22 at 7:35 PM by atkins

Issue with =IF, generating Formula Error: Unexcepted error

Hi! Im having some problems with trying to collecting the values from some of my cells. I want to extract multiple sheets contains both variables and formulas from and .xlsx file and use the logi...

Id #19622 | Release: None | Updated: Apr 20 at 12:33 PM by ksvensk | Created: Apr 20 at 9:59 AM by ksvensk

Date Format

Hi, I use: $objPHPExcelWrite->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH); for format the date in excel (Read from Excel Date/Time. However, when I open the file, I saw o...

Id #19615 | Release: None | Updated: Apr 18 at 5:38 PM by atkins | Created: Apr 18 at 5:38 PM by atkins