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. Quote 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. Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.