If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

You can change the max memory allotment via the memory_limit setting, either via ini_set() in the script, or in an applicable config file.

Personally, I'd look for a way to process one line at a time instead of trying to load it all into memory, if that is practical. One way would be to save the Excel file as a CSV file, then use fopen() and fgetcsv() to read that CSV file one line at a time, processing each line individually.

Already Memory Limit Updated

Originally Posted by NogDog

You can change the max memory allotment via the memory_limit setting, either via ini_set() in the script, or in an applicable config file.

Personally, I'd look for a way to process one line at a time instead of trying to load it all into memory, if that is practical. One way would be to save the Excel file as a CSV file, then use fopen() and fgetcsv() to read that CSV file one line at a time, processing each line individually.

Thanks for the reply. I have already tried the first solution i.e. changing memory_limit in php.ini But it stil does not work even setting the memory_limit= 512M.

However, I will look for the 2nd solution that you have just suggested using fopen() with CSV.