Please don't abuse Steve's services! I've set it so it waits 200ms between requests, so if you're making a lot of requests it might be nice to increase that a bit. It takes in a range of typeIds and optionally a location id, by default it uses The Forge region Id so you get TTT prices. To use it, call the = function from a cell. The code is all visible within your environment, so make adjustments and modifications if you so wish. You'll need to download Script Lab from the Office store (sorry if your version of excel doesn't support add-ins!) Then click on "Import" and paste that link above. However, once I found out you can actually write custom functions in Excel like you can in Google Sheets, I quickly make a script to call the fuzzworks api from within Excel! (Edit: well, you could, but not dynamically or for large queries) Hey yall, I've always hated that you can't (easily) call ESI and other 3rd party API's from within Excel for, you know.
0 Comments
Leave a Reply. |