调试ImportHTML [英] Debugging ImportHTML

问题描述

我正在尝试使用ImportHTML函数在Google表格中创建股息跟踪器.

I'm trying to create a dividend tracker in Google Sheets using the ImportHTML function.

此URL: https://www.google.com/finance?q=VZ 在浏览器中工作正常，但在ImportHTML中出错，声称它无法获取URL(刚刚可用).

This URL: https://www.google.com/finance?q=VZ works fine in the browser, but gets an error in ImportHTML claiming that it cannot fetch the URL (that just worked.)

这是我使用函数的方式:

This is the way I'm using the function:

=IMPORTHTML("https://www.google.com/finance?q=VZ","table",3)

我从各种在线资源中获得了数字3，并且能够导入其他类型的URL.

I got the number 3 from various online resources, and I'm able to import other kinds of URLs.

知道我在做什么错吗?

推荐答案

他们的robots.txt文件包括:

Their robots.txt file includes:

Disallow: /finance?*q=*

换句话说，您没有做错任何事情.

In other words, you are not doing anything wrong.

这篇关于调试ImportHTML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！