Google电子表格importHTML无法获取网址 [英] Google spreadsheet importHTML Could not fetch URL

问题描述

有人可以为我确认吗？

我正在Google电子表格中帮助有人遇到importHTML问题。我不熟悉importHTML，但我认为它应该可以工作。

I'm helping someone with the importHTML problem on Google spreadsheet. I'm not familiar with importHTML but I thought it should work.

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

我不关心我要导入哪张表只要它输入了一些东西。它发出错误消息错误：无法提取网址：http://www.stockq.org/ 。但该网站可以在我的浏览器中访问。

I don't care which table I'm importing so long as it imports something. It's giving out error message Error: Could not fetch url: http://www.stockq.org/. But the web site is accessible in my browser. That's really bizarre.

推荐答案

我的Google Spreadsheet无法处理中文字符，但我在网页上可识别的数字是愉快地进口，至少对三人的中间表而言：

My Google Spreadsheet can't cope with the Chinese characters but numbers recognisable by me on the web page are happily imported, as least for the middle table of the three, with:

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

DigitalSeraphim的方式早在九月份。引用已删除的答案（因为不是答案？）：

This is much what was I think mentioned by @DigitalSeraphim way back in September. To quote from an answer that was deleted (as not an answer?):

所以，我一直在构建一个页面来帮助我保持为我的Minecraft服务器更新mod，大量使用importxml。我发现，对于浏览器中加载绝对正常的一些网站，我得到了同样的错误。进一步研究，我发现这些网站正在报告一个404错误，但实际上返回了请求的数据。根据 https：//drupal.stackexchange。 com / questions / 110651 / how-to-show-a-node-but-return-http-404-response ，这是用来从搜索引擎中删除页面的，正如我所设想的那样。我不认为有没有什么办法解决这个问题，也就是说，建立一个代理服务器来解决状态。

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.

这篇关于Google电子表格importHTML无法获取网址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！