Google Spreadsheets Adds Import Functions, Auto-Fill
Google Spreadsheets just got a bit more powerful. There are four new cell functions to automatically import external data: importXml, importData, importHtml and googleReader.
For instance, importXML has two parameters, URL and an XPath query. Entering =importXML(”http://waxy.org/links/”, “//a/@href”)into a Google Spreadsheets cell and hitting return will load all links from the Waxy.org link blog in the subsequent cells. (I’m not sure if this data is automatically updated or if it’s a one-time fill, though it seems to be auto-updating.) A similar feature had been around in online spreadsheets competitor EditGrid, and so far set EditGrid apart from Spreadsheets in that regard.
Another new feature in Spreadsheets is auto-filling of cells. Enter “Monday” and “Tuesday” in two cells, select them, and click the blue dot on the cell edge to drag it over subsequent cells. They will now read “Wednesday”, “Thursday” and so on. You might know this from other spreadsheet applications, but what’s more, if you hold down Ctrl when you perform this auto-fill, Google will poll data from Google Sets to automatically complete almost anything (at least that’s the theory).
I think auto-filling based on Google Sets is a really cool idea, though during my tests that feature was very unstable, didn’t show a load bar (so you won’t know if there’s something still being polled from Google Sets), and mostly didn’t work at all… or returned results much less relevant than what Google Sets returns, incidentally.
Full source: blogoscoped.com
Zoloft. said,
July 5, 2008 @ 3:12 am
Zoloft lawsuits….
Uncommon side effects of zoloft. Zoloft. Zoloft chlorine interaction. Zoloft and pain killers. Side effects zoloft….
Abilify. said,
July 6, 2008 @ 6:12 am
Abilify….
What is the medication abilify used for. Abilify….
Zoloft or prozac which is better. said,
July 6, 2008 @ 6:44 pm
Zoloft….
Generic zoloft. Zoloft. Zoloft sexual side effects. Side effects of zoloft. Stopping zoloft. Zoloft side affects. Illegal uses for concerta adderall zoloft….
Tramadol dog. said,
July 7, 2008 @ 7:54 am
Side effects tramadol….
Tramadol….
Tramadol soma zoloft prozac onlineprescription.md. said,
July 11, 2008 @ 3:06 pm
Tramadol side effects….
Tramadol discussion. Tramadol….
Abilify. said,
July 14, 2008 @ 3:22 am
Abilify bipolar….
Abilify teens. Medmd and abilify. Pros and cons of abilify….
Abilify. said,
July 15, 2008 @ 2:33 pm
Abilify….
Abilify….
Abilify. said,
July 17, 2008 @ 2:38 am
Cholestasis abilify….
Abilify and kids. Abilify. Abilify im. Abilify mouth sores. Abilify drug interactions. Pros and cons of abilify….
Side effects of lipitor. said,
July 18, 2008 @ 3:08 am
Lipitor and anxiety….
Generic lipitor. Lipitor 20 mg. Lipitor and its bad effects. Lipitor dosage morning or night. Side effects from lipitor. Lipitor vytorin heart attack. Lipitor….
Abilify. said,
July 20, 2008 @ 6:12 am
Abilify and weight gain….
Abilify schizoaffective disorder. Abilify. Abilify injection. Lexapro and abilify. Psych drug name abilify….
Lipitor. said,
July 20, 2008 @ 6:59 pm
Grapefruit and lipitor and cardizem….
Lipitor tablets cholesterol. Lipitor generic. Lipitor side effects. Lipitor….
Abilify and weight gain. said,
July 21, 2008 @ 7:37 am
Abilify….
Abilify….