Laravel Excel

Official:

https://laravel-excel.maatwebsite.nl/

Note: This lib works with PHPExcel which is deprecated already.

Note: When title row is in Chinese, need to change setting in config/excel.php: to_ascii: false;

https://laravel-china.org/topics/2029/laravel-excel-import-excel-file-incomplete-solution

Phpspreadsheet: (phpexcel is deprecated):

https://github.com/PHPOffice/PhpSpreadsheet

Don’t use heading as data key:

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

Example Code:

Export: