[yoman38]

Originally Posted by wyffy

Ok...
Then, why not scraping stat by stat, or all you want?
Do you know how Xpaths works?

For example, if you want to know the Crossing stat, put in a cell:
=IMPORTXML(B3;"//div[3]/div[1]/div[1]/ul[1]/li[1]/span")

If you want the Finishing stat:
=IMPORTXML(B3;"//div[3]/div[1]/div[1]/ul[1]/li[2]/span")

...

I tried it..unfortunaly too much loading time..Hmm excel would be nice

[wyffy]

Originally Posted by ggdaris

oh that be great, can you give a formular to take only this values

Data:
=IMPORTXML(B3;"//div[1]/div[1]/div[@class='meta']")

Nation:
=IMPORTXML(B3;"//div[1]/div[1]/div[1]/a/@title")

Image:
=IMAGE("https://cdn.sofifa.org/players/10/18/" & EXTRAE(A1;(HALLAR("player/"; B3;2))+7;50) & ".png";1)

[wyffy]

Originally Posted by yoman38

I tried it..unfortunaly too much loading time..Hmm excel would be nice

You can load all the data with =IMPORTXML(B3,"//a") in a dirty sheet and hide it.
Import only the data you want in the main sheet with ='Hoja 2'!A1 in each cell

[ggdaris]

Originally Posted by wyffy

Data:
=IMPORTXML(B3;"//div[1]/div[1]/div[@class='meta']")

Nation:
=IMPORTXML(B3;"//div[1]/div[1]/div[1]/a/@title")

Image:
=IMAGE("https://cdn.sofifa.org/players/10/18/" & EXTRAE(A1;(HALLAR("player/"; B3;2))+7;50) & ".png";1)

You are a genius man!! see this


Thanks a lot!!

[yoman38]

Originally Posted by wyffy

You can load all the data with =IMPORTXML(B3,"//a") in a dirty sheet and hide it.
Import only the data you want in the main sheet with ='Hoja 2'!A1 in each cell

But with =IMPORTXML(B3,"//a") the abilities like crossing or so on aren't in the same square depending of loan/international...So I'm stuck

Still it's now better but I need to edit my sheet because of the updates like +1/+3 for some stats...I'll have to leave an empty square between each abilities. It will be long to edit it..I have to do it.

[yoman38]

EXAMPLE: bayern munchen conversion
https://www.youtube.com/watch?v=4lQY...ature=youtu.be