Category Archives: Phpspreadsheet

phpspreadsheet Allowed memory size of xxxxx bytes exhausted

This error could be found in laravel log

Solution: Change memory limit in PHP



Set explicit value of a cell (alphabet coordinate)

By data type

Phpspreadsheet (PHP Excel)

Phpspreadsheet: (phpexcel is deprecated):

Don’t use heading as data key:

/config/excel.php: heading => false;

Setting a cell value by column and row

Retrieving a cell value by column and row


Column Configs for import and export

Export as Excel

Update Excel and export:


Form Example (modal)

Javascript Example

Cell Style