|
Abdiel Vergara - 2013-03-14 18:39:51
Hello Sergey I'm using your class and it works correctly but the only inconvenient is when I try to import a large number of excel rows (example 10,000 rows or more)
please help!
Sergey Shuchkin - 2013-03-14 19:29:25 - In reply to message 1 from Abdiel Vergara
Andre russowsky - 2013-03-14 19:43:50 - In reply to message 2 from Sergey Shuchkin
Increasing memory is not the answer for me, so i made some changes on his class, that i think he is not going to like, but well, if anyone want to use it, feel free.
I can process large files with this changes...
4shared link: http://www.4shared.com/file/1Gsf_BNm/simplexlsxclass.html
Abdiel Vergara - 2013-03-14 19:51:08 - In reply to message 3 from Andre russowsky
Andre
It does so by replacing the file automatically simplexlsx.class.php or to do additional modifications?
Andre russowsky - 2013-03-14 19:57:00 - In reply to message 4 from Abdiel Vergara
Yes just replace, you can use the same methods, i did some new methods for my needs, but you can use the same methods no problem.
Abdiel Vergara - 2013-03-14 21:37:20 - In reply to message 5 from Andre russowsky
Please could you explain what part did the change to allow large amounts of registration without having to make changes in php.ini
Ian Lin - 2015-05-26 20:25:15 - In reply to message 3 from Andre russowsky
Thanks for this fix, I had an issue with a file that was 7k rows, so hoping this will solve the issue. I'll report back. That link is a pain to use. I clicked on like four download buttons and probably got malware before finding the actual file. I hate those sites that try to trick you into downloading something other than what you want.
Ian Lin - 2015-05-26 20:29:48 - In reply to message 3 from Andre russowsky
Okay, I tried it lol and it actually read in 20 less rows than before, nice try though. Maybe my issue is a memory issue? IDK, but will report back once I solve my own issue.
Ian Lin - 2015-05-26 23:21:48 - In reply to message 8 from Ian Lin
I found that the only solution that worked for me was to increase the memory in php.ini. After increasing memory limit, timeout and max execution time variables in php.ini, it read my excel file of 7k rows without any problem. Thanks for this great PHP app!
Bogdan - 2019-10-31 20:18:09 - In reply to message 2 from Sergey Shuchkin
Hello,
Sorry to bug in, but i have a server of 16gb of ram and the memory limit is at 768M, i raised it to 2048M and still it does not work to read a xlsx of around 16000 rows.
Could you please tell me a workaround?
Thanks
|