PHPExcel slow

Topics: User Forum
Dec 30, 2013 at 5:06 AM
I know this is an issue and I have been reading up on it and trying to fix it but still it seems to take a long, long very long time to read only very small files.

Situation: Reading a xls file of (~100kb), creating a reader using setReadDataOnly and setReadFilter (100 rows colums a-z) takes over 30 seconds and takes up over 30 mb.

This is not a lot of data and the file only contains 1600 rows. This means that if I read 100 rows per time it will take 16 page reloads of my application and 8 minutes time to read a simple 100kb file.

I use the develop branch from github and run php 5.5.0 on windows. On my production server I run php 5.4

I need to break up my file since in some occasions I will deal with larger files that have 20,000 rows and try to avoid page time outs without setting the timeout to indefinite.

My questions are:
Am I missing something and thus doing something horribly wrong?
Can I speed up the load method beside doing things that I already did, e.g. the setReadFilter and setReadDataOnly?
Or am I using a wrong branch?