PHP Excel Spreadsheet Viewable Online with Filters/Sorting
 

Hi all,

I have a spreadsheet with many columns, and thousands of rows (5000-1000).

What I'm wondering is, are there any PHP scripts about that will allow me to upload a spreadsheet and allow filtering/sorting on said fields just like an excel document. I also would like the ability to filter on location (Post/ZIP codes) if possible, but if not I can try and add this functionality myself at some point.

The idea is to have a service whereby a users can login and view this spreadsheet (readonly) and use it as if it were a spreadsheet document.

I'm more than happy to sign up to a service (free or paid) which can do this functionality for me if there is such a thing out there? - I tried smartsheet.com but they limit the number of rows to 5000 :(

Anyone got any pointers?

cre

The easiest and quickest way would be to save the spreadsheet in CSV format and import that into a MySQL database. Then use PHP to query the mysql database. Performance should be great this way. Is that an option?

Yeah! I have no idea why I didn't think of that! Its definitely an option, I may have to modify the spreadsheet first

sory cant post urls as yet, but see if any of these help

github.com/DanBricklin/socialcalc

phpexcel.codeplex.com/

Darn :( - #1153 - Got a packet bigger than 'max_allowed_packet' bytes