Obscure GW2Spidy question

Obscure GW2Spidy question

in Players Helping Players

Posted by: Eggman.1405

Eggman.1405

I use this link to copy all the pricing data from the GW2Spidy site into a text file:

http://www.gw2spidy.com/api/v0.9/csv/all-items/all

Then, I import this into Excel 2010. When I am ready to refresh the data after downloading it again from the website, I select the whole page and hit `delete`. When I do this, I get a message from Excel warning me that the data contains a query, and it wants me to confirm that I will be deleting the query.

So, my question for tech mavens is this: what query is this? Is there something embedded in this data that might allow me to have the page refresh itself from the site without me having to manual download and import it?

Obscure GW2Spidy question

in Players Helping Players

Posted by: Azrael.4960

Azrael.4960

Its the query that is created by excel to talk to spidy. If you delete the data in that sheet and remove the query, you won’t be able to use the data refresh function.

I’d recommend using one sheet as your data import and another for information searching