Diablo® III

Getting this information into Excel?

Is there anyway to get this API information pulled into Excel? I've had some experience working with Eve Online API pulls into Excel, but this doesn't seem to be working the same way. I know very little about this stuff, and used the documentation from the Eve Online API pulls to do what I was doing with Eve. This is different somehow though, because when I try to do it through "Data / From Web" and use the URL like "http://us.battle.net/api/d3/profile/Straton-1/" it doesn't work (Of course I'm subbing my own BNet tag for Straton-1)

Any help would be appreciated.

Actually ... nevermind .. the information isn't useful for what I wanted to do with it since I can't seem to figure out how to extract the stats from the items given that all I get is this really long string of letters and numbers as a tooltip param. Unless there's some way to do that, this won't be useful for me putting my characters and gear into a spreadsheet.
Edited by NoCapes#1759 on 9/2/2012 1:49 PM PDT
Reply Quote
Full disclosure, I have no experience/desire to use Excel for something like this and my knowledge of Excel is limited.

What I'd do to solve this problem is look for a JSON to CSV conversion tool (google) and try that. I doubt Excel natively supports json so the first step would be getting the data into a format that Excel can use.
Reply Quote
You could use one of the .NET libraries following the steps on this website:

http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/

This isnt NATIVE excel, but it does allow you to get it to load in excel
Reply Quote
You could also load the jscript engine into excel:

http://stackoverflow.com/questions/6627652/parsing-json-in-excel-vba
Reply Quote

Please report any Code of Conduct violations, including:

Threats of violence. We take these seriously and will alert the proper authorities.

Posts containing personal information about other players. This includes physical addresses, e-mail addresses, phone numbers, and inappropriate photos and/or videos.

Harassing or discriminatory language. This will not be tolerated.

Forums Code of Conduct

Report Post # written by

Reason
Explain (256 characters max)
Submit Cancel

Reported!

[Close]