PHP Classes

excel file of 10,000 rows or more

Recommend this page to a friend!

      SimpleXLSX  >  All threads  >  excel file of 10,000 rows or more  >  (Un) Subscribe thread alerts  
Subject:excel file of 10,000 rows or more
Summary:I have problems importing a file of 10,000 rows
Messages:10
Author:Abdiel Vergara
Date:2013-03-14 18:39:50
Update:2013-03-14 21:37:20
 

  1. excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Abdiel Vergara 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!

  2. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Sergey Shuchkin Sergey Shuchkin - 2013-03-14 19:29:25 - In reply to message 1 from Abdiel Vergara

  3. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Andre russowsky 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


  4. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Abdiel Vergara 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?

  5. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Andre russowsky 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.

  6. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Abdiel Vergara 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

  7. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Ian Lin 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.

  8. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Ian Lin 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.

  9. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Ian Lin 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!

  10. Re: excel file of 10,000 rows or more   Reply   Report abuse  
Picture of Bogdan 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