Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Knitram Relik
Atomic Amish
64
|
Posted - 2016.11.03 23:12:25 -
[1] - Quote
I'm trying to set up a google sheet using the IMPORTXML function to all my character assets.
I kinda get it, but if someone could help me, that would be great. I know a little VBA and I'm a fast learner but I'm stumped on this one.
[WTS] - Signature. 500 mil ISK
|
CowRocket Void
Angelus.Mortis Fidelas Constans
30
|
Posted - 2016.11.05 00:34:01 -
[2] - Quote
IMPORTXML will break. I'm Sure FuzzySteve knows a way.
bleeding shadow darkness > did i just saw a red procurer? :P
|
Zad Murrard
Frozen Dawn Inc Frozen Dawn Alliance
43
|
Posted - 2016.11.05 09:38:05 -
[3] - Quote
=importxml2("https://api.eveonline.com/char/AssetList.xml.aspx?","characterID="&$B3,"&keyID="&$C3,"&vCode="&$D3),"fill-xpath-here",E3))
Where B3 contains your char Id C3 your keyID D3 your vCode and E3 some random number
where it says fill-x-path-here, replace it with your xpathquery
Use importxml2 (google it) as it is more reliable than importxml. Depending on the version you use, you may or may not require the last parameter E3 |
Astrid Farnsworth
Broke and Famous
7
|
Posted - 2016.11.07 03:43:18 -
[4] - Quote
I want somwting like this Hope It work out for you i hace +10 car+ícter and just wanna know hos muchas isk do i hace between all of the.
"Amateurs talk about tactics, but professionals study logistics."
- Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
|
Knitram Relik
Atomic Amish
64
|
Posted - 2016.11.07 11:01:10 -
[5] - Quote
I found this:
https://forums.eveonline.com/default.aspx?g=posts&t=6419
It has everything I needed and more.
[WTS] - Signature. 500 mil ISK
|
Astrid Farnsworth
Broke and Famous
7
|
Posted - 2016.11.09 02:46:57 -
[6] - Quote
I know this app is good for pc, but the reason why i see it useful to have a google doc spread sheep is that you could access it from where ever. talking of Cellphone.
"Amateurs talk about tactics, but professionals study logistics."
- Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |