CookBook > XPathOnUrl

Support
#1

Hi Niels,

In your coobook you give a nice example with XPathOnUrl to scrap the URL http://www.google.com/search?q=dogs&num=10 (in cell A2) with xpath //h3[@class='r']/a (in cell B2) to get 10 results in C2 (via a matricial formula)

Is there a simple solution to modify num=10 to have more line in C2 (for example 100) ?

thanks a lot for your answers

François

#2

Just change the 10 to 100?

#3

Thanks,

But this is the first thing that i have tried. And no, i have still only 10 lines in cell C2. I use Excel 2016. Any Idea to solve this point ?

regards

Pasted image1803×519 25 KB

#4

Google is probably doing something funkty to the source HTML using Javascript. Try to run the XPath trough the PhantomJs Integration.