This warning happens with large sheets or sheets with larger formulas:
PHP Warning: SimpleXMLElement::__construct(): Entity: line 1: parser error : internal error: Huge input lookup in vendor/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/Worksheet.php on line 156
To fix this, on line 156 of vendor/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/Worksheet.php, please change the following:
return new CellFeed(new \SimpleXMLElement($res));
to:
return new CellFeed(new \SimpleXMLElement($res, LIBXML_COMPACT | LIBXML_PARSEHUGE));
This warning happens with large sheets or sheets with larger formulas:
To fix this, on line 156 of vendor/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/Worksheet.php, please change the following:
to:
Thanks!