search

mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP
MIT License
1.84k stars 664 forks source link

I want to know why it is faster than PHPExcel. #237

Closed hvincenty closed 5 years ago

hvincenty commented 5 years ago

I want to know why it is faster than PHPExcel.This makes me very interested.Can you provide relevant information to learn?Thks^_^

mk-j commented 5 years ago

There is a lot less overhead (and features) in PHP_XLSXWriter than PHPExcel. In the end... when you write a row of cells, PHP_XLSWriter writes the file directly to disk, instead of storing each one in a PHPExcel_Cell object in memory like PHPExcel. This makes the size of the spreadsheet limited by the memory_limit in your php.ini.