I'm using google docs to import and display some xml data. The formula I'm using is this:
IMPORTXML("http://ift.tt/1znd1pZ, "/*"))
The returned data is as follows:
<user_statistics>
<last_30_days>49</last_30_days>
<last_7_days>49</last_7_days>
<total_users>1532</total_users>
</user_statistics>
And the spreadsheet displays the following:
________________________
| 49 | 49 | 1532 |
------------------------
I would like however to display the data name along with the data itself so that I could display my data as follows:
__________________________________________________
| last_30_days | last_7_days | total_users |
--------------------------------------------------
| 49 | 49 | 1532 |
--------------------------------------------------
So how can I use xpath to fetch the element's names along with their data?
No comments:
Post a Comment