Web Hosting Talk

Web Hosting Talk (http://www.webhostingtalk.com/index.php)
-   Programming Discussion (http://www.webhostingtalk.com/forumdisplay.php?f=37)
-   -   PHP Excel Spreadsheet Viewable Online with Filters/Sorting (http://www.webhostingtalk.com/showthread.php?t=1131272)


crEA-tEch 02-29-2012 04:49 AM

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

File1eu 02-29-2012 05:38 AM

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?

crEA-tEch 02-29-2012 05:46 AM

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

bops 02-29-2012 05:48 AM

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

github.com/DanBricklin/socialcalc

phpexcel.codeplex.com/

crEA-tEch 02-29-2012 05:49 AM

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


All times are GMT -4. The time now is 09:15 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
© WebHostingTalk, 1998 - 2014. All Rights Reserved.