I did some research and found a div-class example of importXML for Google Sheets (see first sample code below), however it doesn't appear to be working in this instance with a BBC website in Arabic. Does anyone have insight on how to solve this?
=IMPORTXML("http://www.w3.org/","//div[@class='event closed expand_block']//text()"))
=IMPORTXML("http://ift.tt/1KFfkJ6","//div[@class='top-stories__stories']//text()")
Bonus points if anyone can figure how to group the data from individual news stories using JOIN.
Aucun commentaire:
Enregistrer un commentaire