Importxml Question


#1

I’m trying to IMPORTXML

Using:

=IMPORTXML(“http://maplestory.nexon.net/rankings/overall-ranking/legendary?pageIndex=1&character_name=erebusares&search=true&region=&rebootIndex=1#ranking","//img/@src”)

Is there a method i could use to make it list horizontally, instead of vertically?
and/or is there a way to combine =Image with the importxml in a way to show the class=‘avatar’ / class=‘job’

thanks for any help!


#2

ok, i figured out you can use =TRANSPOSE to make it horizontal, but still would like to know how to find class in the Images


#3

@erebusares interesting question!

Let’s work on this example below. Can you elaborate which class in the images you’re referring to?


#4

Hey, sorry for the late reply, but i need the C1 and D1, independently from the other 2.
thank you!


#5

Hey @erebusares,

What do you mean by that?

C1 contains http://msavatar1.nexon.net/Character/CLOENPIFBFGEAKFHFFEKHPKGCLOAAPGGGOOKAKOOJNEOCJELMABIGIJGJHGENFIIGLONDNBDGFELPPEFIOCABHNGCKEGHGKGGBLPNAFOOCNFBDNIOCKMIFNOPMLMLKBNIJLOPEOOEGCHOKNNKBDOBOPCLHDFLHGENDIJLMMELMCGIPIPAJNIOOOFHJDEDNEKIEMLEILFGJFNCFBEMJNPPEBIBNCHIAMMMLFIAGFMOEOKONHIFJFMIMFKJPKKFCHC.png

D1 contains http://nxcache.nexon.net/maplestory/img/icons/icon-job-xenon.gif

What should happen with those values?


#6

so, i was looking for a way to just find those, they have a class of ‘avatar’ and ‘job’, instead of finding all images


#7

@erebusares Google Sheets doesn’t support image classes.

Please schedule a call with me to find a workaround:

https://calendly.com/bobby_

Thanks!