Google Spreadsheet

91 Pandaren Monk
15335
I'm still fairly new to all this, so I may be showing my ignorance. I am making a spreadsheet that has various info about our raiders, and retrieving that info via the WoW API. I'm currently stumped on a couple things:

1. Insert the spec icon inside of a cell.
2. Make the toon name link to their armory page.

Any help with this would be greatly appreciated.
Reply Quote
90 Tauren Paladin
8635
Where you able to figure out how to do this? I am interested on doing the same.
Reply Quote
100 Night Elf Druid
13210
02/23/2013 11:06 PMPosted by Chundashi
1. Insert the spec icon inside of a cell.

http://us.battle.net/api/wow/character/shadowmoon/Firelèáf
http://us.battle.net/api/wow/character/ [server] / [character]
in the json response there is "thumbnail":"shadowmoon/233/92990441-avatar.jpg"
append this to "http://us.battle.net/wow/en/character/" and you should have a picture
... just need to embed it (guess: <img> tags)

02/23/2013 11:06 PMPosted by Chundashi
2. Make the toon name link to their armory page.

http://us.battle.net/wow/en/character/shadowmoon/Firelèáf
http://us.battle.net/wow/en/character/ [server] / [character]
... just need to embed it (guess: <href> tags)
Reply Quote
91 Pandaren Monk
15335
For the spec icon (e.g. Brewmaster, Marksmanship, etc.) I used:range.setFormula('=Image("http://us.media.blizzard.com/wow/icons/36/'+icon+'.jpg")')
where "icon" is the name of the icon as reported by CharacterProfile -> Talents

For the link, i used this:
range.setFormula('=HYPERLINK("http://us.battle.net/wow/en/character/'+realmName+'/'+toon.name+'/advanced", "'+toon.name+'")')
Reply Quote
90 Blood Elf Paladin
12255
@ Chudashi

Do you think you could send me a complete script for the armory links? Been up for hours trying to figure it out and I just keep running into walls. Much appreciated.
Reply Quote

Please report any Code of Conduct violations, including:

Threats of violence. We take these seriously and will alert the proper authorities.

Posts containing personal information about other players. This includes physical addresses, e-mail addresses, phone numbers, and inappropriate photos and/or videos.

Harassing or discriminatory language. This will not be tolerated.

Forums Code of Conduct

Report Post # written by

Reason
Explain (256 characters max)
Submit Cancel

Reported!

[Close]