vendredi 31 juillet 2015

Import data into Google Sheets using IMPORTXML with the div-class

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