PESGaming Associates: Downloads Centre | Soccer Gaming
sponsored by: cedar park lawn service and landscaping
User Tag List

Reply
 
Thread Tools
Old 21-07-2018, 14:46   #16
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Quote:
Originally Posted by wyffy View Post
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


yoman38 is offline   Reply With Quote
Old 21-07-2018, 17:16   #17
wyffy
Registered User
  • Join Date: Jul 2006
  • Location: Basque Country
  • Supports: Athletic Club, AC Milan
  • Posts: 108

wyffy is an unknown

Quote:
Originally Posted by ggdaris View Post
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 is offline   Reply With Quote
Old 21-07-2018, 17:25   #18
wyffy
Registered User
  • Join Date: Jul 2006
  • Location: Basque Country
  • Supports: Athletic Club, AC Milan
  • Posts: 108

wyffy is an unknown

Quote:
Originally Posted by yoman38 View Post
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
wyffy is offline   Reply With Quote
Old 21-07-2018, 18:58   #19
ggdaris
Registered User
  • Join Date: Nov 2014
  • Location: Tucuman - Argentina
  • Supports: River Plate
  • PSN: send me MP
  • Posts: 1,502

ggdaris has discovered the General Forums. God help us.ggdaris has discovered the General Forums. God help us.

Quote:
Originally Posted by wyffy View Post
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!!
ggdaris is offline   Reply With Quote
Old 21-07-2018, 19:23   #20
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Quote:
Originally Posted by wyffy View Post
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 is offline   Reply With Quote
Old 22-07-2018, 18:59   #21
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

EXAMPLE: bayern munchen conversion
https://www.youtube.com/watch?v=4lQY...ature=youtu.be
yoman38 is offline   Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 20:18.

Not yet a member? Register now.

.