0

someone else know how load a bigfile on PHPExcel?

too create a big file, because i use a PHP_XLSXWriter. when can create a big files with out overfloat the ram, but i would like know if anyone know if exist another metohd to work with big files on PHP Excel.

specific load files.

or if PhpSpreadsheet solve it

Thanks.

Yurley Sánchez
  • 37
  • 1
  • How big is your file before it won't work? 1Mb? 50Mb? 100Mb? – scunliffe Apr 16 '18 at 19:42
  • https://github.com/box/spout is the fastest I have seen for php, and it allows you to only read in a line at a time to avoid running out of memory. It's the best when working with larger files IMO – Bryan Apr 16 '18 at 20:30
  • for example in PHP_XLSXWriter use a 250K and is possible configure to write a 1000k of row... and is great. but i would like know if is possible to don't use a memory ram on PHPExcel. – Yurley Sánchez Apr 16 '18 at 20:33
  • Perhaps [reading the PHPExcel documentation](https://github.com/PHPOffice/PHPExcel/blob/develop/Documentation/markdown/Overview/04-Configuration-Settings.md#cell-caching) would answer your question – Mark Baker Apr 16 '18 at 22:33
  • PHPSpreadsheet still uses memory in the same way as PHPExcel..... that's what an "__in memory__" model requires – Mark Baker Apr 16 '18 at 22:34

0 Answers0