CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Allan Thompson
Allan Thompson

Reputation: 171

Importing a website table into Google Spreadsheet

I am trying to import this table into a Google Spreadsheet: League Fixtures and Results The table is available here: https://competitions.lta.org.uk/sport/drawsheet.aspx?id=8D598CDE-8579-4541-B7AD-48558BF6FEA3&draw=4

Before Google changed their Spreadsheet addresses, I had the import working with ImportHTML(URL, "table", 2) - but this no longer works, even though there appears to be only two 'table' labels in the page HTML.

Looking for a way to abstract the table, I went to 'importXML' but tried several versions like 'importxml("https://competitions.lta.org.uk/sport/drawsheet.aspx?id=8D598CDE-8579-4541-B7AD-48558BF6FEA3&draw=4", "//div[contains(@id,'poule')]")' and the same first part of the statement with "//table[contains(@class,'ruler')]") but the formula fails with 'no content'

Would really appreciate some help to find a way to import this table! Thanks in anticipation,

Upvotes: 0

Views: 1314

Answers (1)

David Salomon
David Salomon

Reputation: 849

The reason you can't get the table data is because of the cookies page

enter image description here

Every time Google Sheets is trying to access that link, you need to accept cookies, and by default, Google Sheets won't do it.

You need to bypass or accept the cookies from the website to access data, you will need to implement more advanced things in Python or Google Apps Script

Upvotes: 0

Related Questions