portphp icon indicating copy to clipboard operation
portphp copied to clipboard

Published 20 hours ago • verified publisher icon portphp

Use box/spout instead of phpoffice/phpexcel

Open garak opened this issue 7 years ago • 9 comments

garak avatar Oct 15 '17 19:10 garak

Why? What are the advantages?

ddeboer avatar Dec 08 '17 16:12 ddeboer

Memory consumption on large data

garak avatar Dec 08 '17 16:12 garak

Good point, @garak! Is this something you want to work on? We should create a separate portphp/spout repository for box/spout readers and writers.

ddeboer avatar Dec 10 '17 10:12 ddeboer

OK

garak avatar Dec 10 '17 16:12 garak

Created the repo at https://github.com/portphp/spout. @garak Please proceed by creating a PR against that repo. Feel free to add yourself as an author to the readme and composer.json. Thank you very much!

ddeboer avatar Dec 10 '17 16:12 ddeboer

@garak Did you start an implementation ?

aaa2000 avatar Feb 08 '18 20:02 aaa2000

not yet

garak avatar Feb 09 '18 09:02 garak

I noticed the array buffering in portphp/excel. The next thing I was going to work was that. If PHPOffice/Spreadsheet has some kind of iterable interface, then we could use that instead of buffering with toArray()

infomaniac50 avatar Jul 16 '18 21:07 infomaniac50

Of course PHPOffice has something like this. https://phpspreadsheet.readthedocs.io/en/develop/topics/accessing-cells/#looping-through-cells

infomaniac50 avatar Jul 16 '18 21:07 infomaniac50