Google地图Xpath使用Google电子表格IMPORTXML [英] Google Maps Xpath using Google Spreadsheet IMPORTXML

问题描述

我试图在Google电子表格中使用IMPORTXML函数从谷歌地图结果中使用拉数据，但是我收到错误＃N / A

= importxml（ http://maps.google.com/maps?q=cosmetic+surgeon+NEAR+New+York%2C+NY%2C+United+States&output=classic&dg=ntvb ，// DIV [@ class ='name lname']）

或

= importxml（ http://maps.google.com/maps?q=cosmetic+surgeon+NEAR+New+York%2C+NY%2C+United+States&output=classic&dg=ntvb,//SPAN [@ class = 'pp-place-title']）

但没有任何工作..任何想法???

Thanks

解决方案

如果您要给importxml literal str作为参数，它们需要双引号：

= importxml（http://maps.google.com/maps?q =化妆品+外科医生+ NEAR + New + York％2C + NY％2C + United + States& output = classic& dg = ntvb，// div [@ class ='name lname']）

I am trying to use Pull data from google maps results using IMPORTXML function in google spreadsheet but I am getting error #N/A

=importxml(http://maps.google.com/maps?q=cosmetic+surgeon+NEAR+New+York%2C+NY%2C+United+States&output=classic&dg=ntvb,"//div[@class='name lname'])

or

=importxml(http://maps.google.com/maps?q=cosmetic+surgeon+NEAR+New+York%2C+NY%2C+United+States&output=classic&dg=ntvb,//SPAN[@class='pp-place-title'])

but nothing is working.. Any thoughts???

Thanks

解决方案

If you're going to give importxml literal strings as arguments, they need to be double-quoted:

=importxml("http://maps.google.com/maps?q=cosmetic+surgeon+NEAR+New+York%2C+NY%2C+United+States&output=classic&dg=ntvb", "//div[@class='name lname']")

这篇关于Google地图Xpath使用Google电子表格IMPORTXML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！