Top "Phpspreadsheet" questions

PhpSpreadsheet is a library written in pure PHP and providing a set of classes that allow you to read from and to write to different spreadsheet file formats, like Excel and LibreOffice Calc.

PHPSpreadsheet: how to get the number of loaded rows?

How do I find out how many rows I have loaded using PHPSpreadsheet\Reader\Xlsx::load() method? I cannot find …

php excel phpspreadsheet
Center all text in PHPSpreadsheet and make the cells expand to fill up with context

I struggle a bit to make all the cells set the context to center and to autoexpand so it doesnt …

php spreadsheet styling phpspreadsheet
Building very large spreadsheet with PHPSpreadsheet

I'm testing out how PHPSpreadsheet works with large excel spreadsheets. Initial tests indicate that for a large spreadsheet one will …

php excel memory phpspreadsheet
Download PhpSpreadsheet file without save it before

I'm using PhpSpreadsheet to generate an Excel file in Symfony 4. My code is: $spreadsheet = $this->generateExcel($content); $writer = new …

php-7 symfony4 phpspreadsheet
How to change cell color in PHPSpreadsheet

Are you able to change the color of a cell in a .xlsx file with PHPspreadsheet? Couldn't find anything in …

php phpspreadsheet
PhpSpreadsheet - Download file instead of saving it

I need to generate an excel file (xls) and trigger the download after it is generated. I found this example …

php phpspreadsheet
How to use PHPSpreadsheet in CodeIgniter 3 to read data from Excel (.xlsx and .xls) file?

Recently in one of my CodeIgniter based project, I need to read data from Excel file ( .xlsx and .xls ) and …

php codeigniter phpspreadsheet
How to set money format in PhpSpreadSheet?

I'm using PHPSpreadSheet and I want to set money format for a cell. In PHPExcel you can do this by …

php phpexcel phpspreadsheet
Read Xlsx file in PhpSpreadsheet

I want to read an xlsx file that was created in Microsoft Excel, but when I run the following code... $…

php excel xlsx ziparchive phpspreadsheet
Read XLS in PHP using PhpSpreadsheet

I have a requirements to read XLS files (not xlsx) using PhpSpreadsheet and I having trouble. I tried this (as …

php excel xls phpspreadsheet