Hello In Google Docs I am able to use the:
Formula:
=(importXml("http://api.eve-central.com/api/marketstat?&typeid=34®ionlimit=10000002","//sell/min"))
Function to take dynamic data from a web based updating XML sheet and import only a single piece of data:
//sell/min
1.jpg
In Excel I am attempting to use:
Formula:
=FILTERXML("http://api.eve-central.com/api/marketstat?&typeid=34®ionlimit=10000002","//sell/min")
As it seems to be the only thing that resembles the Google Docs function above.
When I use this though I get a #VALUE! error where in Google Docs I get the correct data.
2.jpg
I can use the import from web function to pull the data down one line at a time and then make a reference on my main sheet to the data I need but this is impractical because I will need to do this for 20,187 entries.
Also when I imported the data from the web for just one of them when I attempted to (Refresh All) I get an error stating:
Capture.JPG
I then press enter and get:
1.PNG
I press Ok and it loops back to the previous error and does not actually update anything.
If I however go into connections and update connection 3 It actually updates the data "I think" with live information.
~~ ~~ ~~ ~~
All in all I need a way to import all 20,187 pieces of specific information as easily as possible and it needs to be able to be quickly updated.
Bookmarks