Natalino

Picone

Tech machine


QUERY Function for Google Spreadsheets

settembre 11, 2009Nat0 Comments

André “Ahab” sent in this news bit (URLs shortened):

Google Docs added a new powerful function to its spreadsheets: the QUERY function. This function allows SQL-like queries using the Qviz Gviz syntax (albeit a bit limited version: only directly referenced ranges can be used and column IDs always have to be column letters). Think of QUERY as a next version of the already very powerful Google Docs specific FILTER function.

If you wished Google Docs spreadsheets should be a bit more accessible like a database, this function is a wish come true. It does not turn your spreadsheet into a full database – you can’t use SQL like inserts, updates and deletes – but as a way to pull data fom one’s sheet of data QUERY is unsurpassed because of its build-in versatility.

See: www.google.com/support/forum/p/G…
Look for the post of Google Docs Guide Christine at [September] 8, 2009 and following posts.

See also the Google Docs spreadsheet help on the Query function: docs.google.com/support/bi… and the [related] information on the Qviz Gviz Query Language syntax as used by the QUERY function: code.google.com/apis/visualiz…

[Thanks Ahab!]

[By Philipp Lenssen | Origin: QUERY Function for Google Spreadsheets | Comments]

[Advertisement] Google books on Amazon