Can I open excel before I populate the xls?

Jun 7, 2011 at 12:44 PM

Hello,

I've implemented PHPExcel, and it works great! Exactly what I needed. But when I am loading 2000+ records from a DB with PHPExcel, it takes a while to for the Open/Save popup to appear (10-15 seconds). I was wondering if it's possible to code it, that it opens up Excel first and then start populating the rows on the fly (while excel is already open).

I'd like to implemented it this way, so that the user isn't waiting for the 'Open' or 'Save' dialog. A little more visually appealing

Any help would be great.

Thanks!

Jun 14, 2011 at 12:22 PM

Anyone have any ideas?

Jun 14, 2011 at 3:17 PM

I do not know PHPExcel, so this is just a guess.

You seem to be averaging one to two seconds per hundred.
You've at least a couple of options.  In both cases, I'm assuming
that you have a row count.

(a) you could print a message like:
            nnnn rows to display, estimated time nn seconds.
      every three to five seconds, you could update the above message.

(b) you could display the first 100 rows, with row 101 saying
     how many rows left, you could update that every 200 to 300 rows,
     if you want to keep refreshing.

g.