google-sheets - Google 电子表格 importHTML 无法获取 URL

Question

有人可以帮我确认一下吗？

我正在帮助某人解决 Google 电子表格上的 importHTML 问题。我不熟悉 importHTML 但我认为它应该可以工作。

=importhtml("http://www.stockq.org/","table",1)

我不在乎我要导入哪个表，只要它导入了一些东西。它发出错误消息 Error: Could not fetch url: http://www.stockq.org/ .但是可以在我的浏览器中访问该网站。这真的很奇怪。

Answer 1

我的 Google 电子表格无法处理中文字符，但我可以在网页上识别的数字很高兴地导入，至少对于三者中的中间表，具有:

=importhtml("http://www.stockq.org/","table",A12)  

这就是我认为 @DigitalSeraphim 早在 9 月份就提到的内容。引用已删除的答案(作为不是答案？):

So, I have been building a page to help me keep up with mod updates for my minecraft server, using importxml heavily. I have found that I get the same error for some sites that load absolutely fine in the browser. Looking into it further, I found that the sites are reporting a 404 error, but actually returning the data requested. According to https://drupal.stackexchange.com/questions/110651/how-to-show-a-node-but-return-http-404-response, this is used to remove pages from search engines, as I had assumed. I don't think there is any way around this without some hackery... namely, setting up a "proxy" server that would "fix" the status.

However, it appears that the example you gave is now working, so maybe give it another try.