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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Importing into Excel
Author
Previous Topic Next Topic
Reed Preston
Center for Advanced Studies
Gallente Federation
#1 - 2014-02-14 01:47:18 UTC
Hello.

I'm trying to import data from Eve Addicts into Excel. I know how to do it but I'd like to do it without it automatically creating a title bar with "ID, Buy Price, Sell Price."

I have a long list of items, too many to do with one entry and I do not want that bar beginning each download, I'm trying to put it all in one table and don't need the title.

I tried using EVE-Central, but there doesn't seem to be a way to only grab the exact data I want rather than having it give everything.

I hope that makes sense.

Plan B is obviously to create a data-sheet and use vlookup to transfer what I need to the main one, but if this is possible I think it would be easier for me as I want to save it in CSV and it doesn't like there being more than one worksheet.

I'm not as experienced with all this as I plan to be, so I apologize if this is rather mundane, my repeated searches did not reveal the answer.

Thanks.
Achanjati
Royal Amarr Science Institute
#2 - 2014-02-14 10:37:07 UTC
What buy price? What sell price? The lowest, the highest, the average...
eve-central gives you all because there is not just "one" sell price.
If there are to many values which you just don't need, have you tried to just hide these values?
Hel O'Ween
Men On A Mission
#3 - 2014-02-14 14:43:26 UTC
What about EVE Marketdata?

EVEWalletAware - an offline wallet manager.
Adunh Slavy
#4 - 2014-02-14 17:05:45 UTC
Make some macros that clean up the data after import. Can even assign them to buttons.

Macros are easy to make, you don't need to know how to code, but can go into the macro, after it is created, and modify the code if you want.

Necessity is the plea for every infringement of human freedom. It is the argument of tyrants; it is the creed of slaves.  - William Pitt