Category Archives: Phpspreadsheet

Phpspreadsheet (PHP Excel)

Phpspreadsheet: (phpexcel is deprecated):

https://github.com/PHPOffice/PhpSpreadsheet

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

Reference:

Export Excel

Update Excel and export:

Import: