tags:

views:

18

answers:

0
Q: 

How do I return multiple columns of data using ImportXML in Google Spreadsheets?

I'm using ImportXML in a Google Spreadsheet to access the user_timeline method in the Twitter API. I'd like to extract the created_at and text fields from the response and create a two-column display of the results.

Currently I'm doing this by calling the API twice, with 

=ImportXML("http://twitter.com/status/user_timeline/matthewsim.xml?count=200","/statuses/status/created_at")

in the cell at the top of one column, and 

=ImportXML("http://twitter.com/status/user_timeline/matthewsim.xml?count=200","/statuses/status/text")

in another.

Is there a way for me to create this display with a single call?

related questions

Set cell format in google spreadsheet using python api
Accessing Google Spreadsheets with C# using Google Data API fails with Mono
Php Form data to Google Spreadsheets
Import JSON data into Google Spreadsheet
How safe am I signing into Google Spreadsheets with yeroon.net/ggplot2
Can I access a (private) google spreadsheet by inserting a password in the URL ?
Insert hundreds of rows into Google spreadsheet with Zend Gdata?
How to display Google Online Spreadsheets in browser using Servlets
Google Spreadsheet multiple column filter using OR
Run Google apps script on Google-Spreadsheet event?
accessing variable sheet ranges within Google spreadsheet?
How can I convert Excel VBA to Google spreadsheets Javascript API?
What's the right tool for this job in Google Spreadsheets?
Making a simple searchable directory of people and their skills in a day - Which technologies?
How do I insert a row in to a Google spreadsheet using c#
using Zend_Gdata_Spreadsheets for public spreadsheets?
Google Doc Api: Spreadsheets with Charts
Google Spreadsheets API - updateCell via PUT or PHP?
How to save data in unpublic google spreadsheet using PHP without Zend Gdata library?
What is the function to return the name/address of a cell or range (Spreadsheet)?
How to use the Google SpreadSheets API to feed data to an application?
python + Spreadsheet
Google Docs Spreadsheet Automatic Coloring
What would be the spreadsheet function to sum all values in one column based on criteria from another column (I'm using google spreadsheet)