Reader - Load by row range

Topics: Developer Forum
Oct 15, 2008 at 5:30 PM
Hi,
These Excel classes you've created are great.

I'm developing web based applications for my customers.
In recent development, the user can upload an Excel file and the web-app analyzes the file.
The thing is that my clients upload large Excel files, usually containing way over 20,000 rows and 15-20 columns.

My application gets the "memory limit exhausted" whenever the $objReader->load($filename) is being called for a large file.
It seems that the "load" function loads the entire worksheet to memory. (unless the sheet limitation is set, but in my case all data is in the same sheet)
Is there a way to set the reader to only load rows X through Y, so I can loop through the file and load 1,000 rows on every recurrence?

Cheers,
Amit Koren.
Developer
Oct 16, 2008 at 6:00 AM
Feature request copied to issue tracker where discussion can continue:
http://www.codeplex.com/PHPExcel/WorkItem/View.aspx?WorkItemId=7828