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.
 

Possible to use array's in ImportXML functions
Author
Previous Topic Next Topic
Jim Augus
State War Academy
Caldari State
#1 - 2013-05-17 17:49:06 UTC
=importXML("https://api.eveonline.com/eve/TypeName.xml.aspx?ids="&N47&","&N48&","&N49&","&N50&","&N51&","&N52&","&N53&","&N54&""

So for instance I am trying to create a googledocs database for hangar contents. I have one function that pulls all the typeid's of a specific location. Next column I have the above function to translate all the typeid's into the items actual name. The limit on this is 250 typeid's.

My question is there a way to utilize an array of cells rather than having to do "&N47&","&N48&","&N49&","&N50&","&N51&","&N52&","&N53&","&N54&"" and manually input each and every cell?

For instance something along the lines of "&N47:N54&" (this doesnt work but hopfully shows what im trying to do).

Thanks,
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-05-17 18:53:29 UTC