asimlqt / php-google-spreadsheet-client

A PHP library for accessing and manipulating Google Spreadsheets
Other
543 stars 154 forks source link

Insert rows on LARGE spreadsheets #80

Closed mattimatti closed 9 years ago

mattimatti commented 9 years ago

I leave this warning to those like me implemented the library in their proyects.

Althought the library works like a charm inserting rows in relatively small spreadsheets, when it comes to large spreadsheets you should avoid using the getListFeed method:

$worksheet = .....
$row = array(.....);

// this call will download all the spreadsheet.
$listFeed = $worksheet->getListFeed();

$listFeed->insert ( $row);

The consequence are to run out of memory and fail badly.