These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Google Sheets

Author
Kosomot
Player Vs Ore
Miners Of Independence
#1 - 2017-02-15 23:19:52 UTC
So i'm not 100% sure this is the right forum for this since it's not directly about EVE technology however i'm sure people here are experts.

So i'm building myself and corpmates a PI spreadsheet leveraging buy/sell pricing from eve central.

I'm using google sheets because, well because.

What i'm finding is that the IMPORTXML function fails more often than it works.

Now I'm entirely onboard with the fact that i might be doing something wrong.

data will load from eve central, show me the prices and then POOF gone, i getting errors about not being able to resolve the URL,

That said if i take the URL and plug it into a browser and it works just fine.

Is this Google Sheets misbehaving, my own idoicy, or somethign else.

Just looking for a bit of feed back before i jump to excel to get this done.

Thanks

KOSO

I am a miner, mission runner, and explorer...

or as EVE Online would have it...

A Carebear!!

Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2017-02-22 07:27:32 UTC
Importxml special behavior.

Use importxml2.