How to get an element's name with XPATH?



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