提供内部错误的ImportXML查询

Question

我刚刚编写了我的第一个ImportXML函数来获取这样的产品。我想获取所有的h3元素。但它展示的是import internal error。

=ImportXML("https://www.google.com/products?q=ipod+nano","//h3")

我也尝试过这个查询给所有h3元素类r，但是它仍然显示相同的错误？

=ImportXML("https://www.google.com/products?q=ipod+nano",
                "//h3[@clsass='r')")

Answer 1

正如@MarcusRickert已经指出的那样，HTTPS页面可能是一个问题。使用它们的HTTP版本：

=IMPORTXML("http://www.google.com/search?tbm=shop&q=ipod+nano&gws_rd=ssl", "//h3")

结果是(剪辑)：

Apple iPod Nano (6th Generation) - 8 GB - Graphite
Apple iPod Nano (3rd Generation) - 4 GB - Silver
Apple iPod Nano (4th Generation) - 8 GB - Pink
Apple iPod Nano (PRODUCT) RED (7th Generation) - 16 GB - Red
Apple iPod Nano (2nd Generation) - 4 GB - Silver
Apple iPod Nano (5th Generation) - 8 GB - Black
Apple iPod Nano (4th Generation) - 8 GB - Silver
Apple iPod Nano (7th Generation) - 16 GB - Space Gray
Apple iPod Nano (5th Generation) - 16 GB - Black
Apple iPod Nano (2nd Generation) - 4 GB - Green
.....

对第二个查询也进行同样的操作。同样，由于在XPath表达式中发现了两个错误，所以应该归功于马库斯。试着更小心地写那些表达！特别是，如果您两次查看代码，那么clsass而不是class应该很容易捕获。

=IMPORTXML("http://www.google.com/search?tbm=shop&q=ipod+nano&gws_rd=ssl", "//h3[@class='r']")

结果：

Apple iPod Nano (7th Generation) - 16 GB - Slate
Apple iPod Nano (6th Generation) - 8 GB - Graphite
Apple iPod Nano (3rd Generation) - 4 GB - Silver
Apple iPod Nano (4th Generation) - 8 GB - Pink
Apple iPod Nano (PRODUCT) RED (7th Generation) - 16 GB - Red
Apple iPod Nano (2nd Generation) - 4 GB - Silver
Apple iPod Nano (5th Generation) - 8 GB - Black
Apple iPod Nano (4th Generation) - 8 GB - Silver
Apple iPod Nano (7th Generation) - 16 GB - Space Gray
Apple iPod Nano (5th Generation) - 16 GB - Black
Apple iPod Nano (2nd Generation) - 4 GB - Green
Apple iPod Nano (3rd Generation) - 8 GB - Pink
Apple iPod Nano (PRODUCT) RED Special Edition (2nd Generation) - 4 ...
Apple iPod Nano (1st Generation) - 2 GB - White
Apple iPod nano (PRODUCT) RED Special Edition (6th Generation) - 8 ...
Apple iPod Nano (PRODUCT) RED Special Edition (3rd Generation) - 8 ...
Apple iPod Nano (PRODUCT) RED Special Edition (5th Generation) - 8 ...
Engraved Apple iPod Nano 16GB - 8th Gen
Apple 16GB iPod nano (Blue) Brand new
Apple iPod Nano (3rd Generation) - 8 GB - Green