- Jan 31, 2005
- 9,454
- 0
- 0
I would like to quickly create bulk XML queries in Excel, but am not sure how to do this. For example, in Google Docs I can type the following into a cell...
=ImportXML("http:/mywebsite/api/orders?name=1&usesystem=Southeast")
And Google Docs will run the query. However when I that into an Excel cell it doesnt work. I need to go through the process of actually accessing the Developer tab, setting up the source etc etc and its quite cumbersome.
I'd like a quick way yo do this for hundreds of items (Items 1-x). Now I can put the first command into a text editor and quickly edit it to hundreds of queries, 1 per line and paste it into Google Docs. Isnt there a quick way to do this in Excel?
Thanks
=ImportXML("http:/mywebsite/api/orders?name=1&usesystem=Southeast")
And Google Docs will run the query. However when I that into an Excel cell it doesnt work. I need to go through the process of actually accessing the Developer tab, setting up the source etc etc and its quite cumbersome.
I'd like a quick way yo do this for hundreds of items (Items 1-x). Now I can put the first command into a text editor and quickly edit it to hundreds of queries, 1 per line and paste it into Google Docs. Isnt there a quick way to do this in Excel?
Thanks
Facebook
Twitter