Apr 17, 2010 at 12:10 PM
Edited Apr 17, 2010 at 12:15 PM
I'm using PHPExcel @version 1.7.2 with PHP Version 5.2.9 on Windows NT 5.1 build 2600.
Is there a way for me to determine something like
without having to load the entire worksheet first? I'm trying to serve up an HTML table spreadsheet in chunks due to the very large size. I'd like to initially load say the first 100 rows, then have ajax lazy load additional rows as the user
scrolls down. I plan on using a custom read filter to only grab several rows at a time, but when I initially draw the table, I need to know what headers to draw (A-???).
For instance, if the highest column in the first 50 rows is E, but there's data in row G54, I wouldn't have written a table header pasts E when I first drew the table, so I'm hosed.
So, what's the best way to determine the highest populated column for a spreadsheet without loading the entire sheet in to memory?
Also, right now, I'm getting a list of spreadsheet names by loading the file with a read Filter that basically includes nothing (spreadsheet name = "somebogusname"). I'm able to use the worksheet iterator and loop through to get my names,
Is there a more ellogant way to get the spreadsheet list without having to evaluate every cell with a read filter?
Thanks in advance!