Results 1 to 1 of 1

Need assistance importing xml data into a spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013/2010
    Posts
    1

    Need assistance importing xml data into a spreadsheet

    Hello In Google Docs I am able to use the:

    Formula: copy to clipboard
    =(importXml("http://api.eve-central.com/api/marketstat?&typeid=34&regionlimit=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: copy to clipboard
    =FILTERXML("http://api.eve-central.com/api/marketstat?&typeid=34&regionlimit=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.
    Attached Images Attached Images
    Last edited by Titortian; 01-02-2013 at 11:32 AM. Reason: Replaced copy error in formula bars

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1