Do you have a way to report PHPExcel errors? Specifically, we run into issues with large file sizes. I can increase the memory and time-out issues, but it would be nice if I could report the cause to the end-user rather than the standard HTTP 500 page.
Ideally if the PHPExcel failed due to a size-limit it would pop-up a warning to the user the file-size has exceeded and to filter the results.
Any thoughts on how this could be accomplished?
Thanks
Mike
I’ve not tested this approach, but by some research i found this discussion asking for similar case.
phpexcel is not good for big files and memory leak issues are all over stackoverflow. To disable it, just rename folder ‘phpexcel’ to something else and it will fallback to previous excel export library. It might give you better results.
PHPExcel works pretty-well perfectly for all but the largest reports. Which really shouldn’t be exported anyway – it kind-of defeats the searching/filtering capabilities of the report engine.
I will review the site you gave me – it looks like some good information and might help.
Thanks
Mike