Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

I am trying to pull the table from https://rotogrinders.com/schedules/nfl into Google Sheets

I tried using ImportHTML("https://rotogrinders.com/schedules/nfl", "table", 1) but it just returns the header:

Time Team Opponent Line Moneyline Over/Under Projected Points Projected Points Change

Using ImportXML, I tried IMportXML("https://rotogrinders.com/schedules/nfl","//tr"), but it returns the same header and no data.

I dont think the tbody needs authentication to access. I logged out, cleared my cache and even tried on another computer and still no tbody.

I know its a table called "tschedules", but cant get the data

Is there another part of the XPATH I am missing?

This is the XPATH from google scraper: "//table[1]/tbody/tr[td]"

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
187 views
Welcome To Ask or Share your Answers For Others

1 Answer

When you load this website the actual table doesn't load in for a few seconds. This is why you're not seeing any data come in. If you can set some wait time on that import call somehow then it would work.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...