ironwood40
New Member
- Joined
- Sep 25, 2012
- Messages
- 7
Good Morning All:
I am an online MMORPG gamer, FFXIV or Final Fantasy 14, is my current game of choice. In the game you hunt for items, get things awarded for accomplishing task, etc. It builds up quite an inventory of things of which you have limited storage. You can also have up to 4 retainers that you can transfer things to to "hold" for you. All of this information can be accessed out of the game thru a passworded website that shows your character attributes, skills and most of all inventory. Here is a snip from one of my retainers:
What I am looking to do is to find a way to grab this information and drop it into a spreadsheet that I can keep a list of each of my 5 characters and their inventory. Copy and paste does not work, it puts it all into 1 or 2 fields. I have tried importing to Excel using the get data from web command, but as mentioned, this is a passworded site so it will only access the start page. Each character can store up to 175 items so a process that can grab the info and get it into Excel is going to make my life so much easier. Please let me know if you need more information and I look forward to your suggestions.
I am an online MMORPG gamer, FFXIV or Final Fantasy 14, is my current game of choice. In the game you hunt for items, get things awarded for accomplishing task, etc. It builds up quite an inventory of things of which you have limited storage. You can also have up to 4 retainers that you can transfer things to to "hold" for you. All of this information can be accessed out of the game thru a passworded website that shows your character attributes, skills and most of all inventory. Here is a snip from one of my retainers:
What I am looking to do is to find a way to grab this information and drop it into a spreadsheet that I can keep a list of each of my 5 characters and their inventory. Copy and paste does not work, it puts it all into 1 or 2 fields. I have tried importing to Excel using the get data from web command, but as mentioned, this is a passworded site so it will only access the start page. Each character can store up to 175 items so a process that can grab the info and get it into Excel is going to make my life so much easier. Please let me know if you need more information and I look forward to your suggestions.
