kamal213 Posted October 10, 2011 Share Posted October 10, 2011 Hi guys, I exported my database table in excel format and when I open get the following error: [qoute]<br /> <b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tried to allocate 60 bytes) in <b>C:\xampp\phpMyAdmin\libraries\PHPExcel\PHPExcel\Worksheet.php</b> on line <b>920</b><br />[/qoute] Any ideas? One solution I came up with was to export as CSV for Excel but unfortunately all the entries are with commas so I like to convert the CSV file into XLS please I need you help guys thanks. Link to comment https://forums.phpfreaks.com/topic/248803-error-when-exporting-sql-table-in-excel-97-2003-format/ Share on other sites More sharing options...
kamal213 Posted October 10, 2011 Author Share Posted October 10, 2011 Hi guys, I exported my database table in excel format and when I open get the following error: <br /> <b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tried to allocate 60 bytes) in <b>C:\xampp\phpMyAdmin\libraries\PHPExcel\PHPExcel\Worksheet.php</b> on line <b>920</b><br />[/qoute] Any ideas? One solution I came up with was to export as CSV for Excel but unfortunately all the entries are with commas so I like to convert the CSV file into XLS please I need you help guys thanks. Link to comment https://forums.phpfreaks.com/topic/248803-error-when-exporting-sql-table-in-excel-97-2003-format/#findComment-1277753 Share on other sites More sharing options...
awjudd Posted October 10, 2011 Share Posted October 10, 2011 Your table is likely huge, so you would need to expand the amount of allowable memory for PHP. ~juddster Link to comment https://forums.phpfreaks.com/topic/248803-error-when-exporting-sql-table-in-excel-97-2003-format/#findComment-1277756 Share on other sites More sharing options...
fenway Posted October 10, 2011 Share Posted October 10, 2011 Or just paginate. Link to comment https://forums.phpfreaks.com/topic/248803-error-when-exporting-sql-table-in-excel-97-2003-format/#findComment-1277914 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.