Sorting Embedded Google Spreadsheets

August 11, 2008 1:25 PM

I am looking for a way to sort embedded Google Spreadsheets. I am not looking for advanced features or interacting with the data, but ONLY client side sorting.

I published a testing spreadsheet
http://spreadsheets.google.com/pub?key=po4odZe1pIMzeFaoYQQz6BQ&output=html&gid=0&single=true&range=A1:D11

On http://ask.metafilter.com/89827/How-to-make-spreadsheet-dynamically-sortable-web-table unixrat said he is sure embedded Google Spreadsheets are able to be sorted.

I have seen this can be done with Zoho: http://blogs.zoho.com/sheet/how-to-embed-your-spreadsheet-into-any-webpageblog/, but that solution offers the visitors too many options. If the ability to edit the cell contents was disabled, but still sortable, that would work also.

My thought is I am missing some documentation in the Google Data API, if anyone can point out links that I need to read to be able to add sorting, I would appreciate it.

posted by joemako to Computers & Internet (2 answers total)

I've been wishing for an API-ish way to "query" a Google spreadsheet like a database myself ("give me row 22" or "give me column 4 of the first row matching "Anderson, Gillian") but as far as I can find, that level of granularity just isn't there... yet?
posted by rokusan at 1:52 PM on August 11, 2008

Response by poster: @rokusan, you may be looking for: http://code.google.com/apis/spreadsheets/developers_guide_python.html
posted by joemako at 8:25 PM on August 11, 2008