Top "Phpexcel" questions

A PHP library to create, read, edit and write spreadsheet files for MS Excel and other spreadsheet programs

PHPExcel runs out of 256, 512 and also 1024MB of RAM

I don't understand it. The XSLX table is about 3MB large yet even 1024MB of RAM is not enough for …

php phpexcel
How do I read sheet two of an xlsx file with PHPExcel?

I know how to read my xlsx spreadsheet and loop through the first sheet. It has 5 sheets and I am …

php phpexcel import-from-excel
PHPExcel: Download the Excel file on the client side

The problem was solved: For other users that may have this problem - notice the encoding of the PHP file. …

php phpexcel
PHPExcel very slow - ways to improve?

I am generating reports in .xlsx using PHPExcel. It was okay in the initial testing stages with small data sets (…

php spreadsheet phpexcel
How to read large worksheets from large Excel files (27MB+) with PHPExcel?

I have large Excel worksheets that I want to be able to read into MySQL using PHPExcel. I am using …

php phpexcel
How to use PhpSpreadsheet without installation (like PHPExcel)

According to the PhpSpreadsheet Doc it's neccessary to install it with composer. In my case I just have a webspace …

php phpexcel phpspreadsheet
PHPExcel: Setting font size?

I have been looking to change the font size of some Excel cells using a PHP library called PHPExcel. This …

php phpexcel
PHPExcel file cannot open file because the file format or file extension is not valid

I'm stuck with this problem, it's not displaying the actual excel file. Please check my code below: /** Error reporting */ error_…

php phpexcel
How to PHPExcel set auto-columns width

I'm working with PHPExcel to export data for download. When open downloaded files, with cells have big number, it show "#######" …

php width phpexcel autosize
how to get date from excel using PHPExcel library

I am trying to get Date from excel using PHPExcel. But I am not getting date, I am getting string …

php date phpexcel