问题描述
我要在" https://www.screener.in/screens/1/The-Bull-Cartel/"添加到我的Google表格中.我尝试使用IMPORTDATA,IMPORTHTML,但是没有用.我了解这些表是Javascript.我对Java或代码一无所知,我确实在尝试学习.请帮助我完成导入数据的过程.
I want to import table in "https://www.screener.in/screens/1/The-Bull-Cartel/" to my Google sheets. I tried to use IMPORTDATA, IMPORTHTML but it didn't work. I understand that the tables are of Javascript. I don't know about Java or code and I am really trying to learn. Kindly help me with the procedure for importing data.
我使用的公式是 IMPORTDATA("https://www.screener.in/screens/1/The-Bull-Cartel/")
导致产生一些Java类型的输出,看起来像此
The formulas that i used areIMPORTDATA("https://www.screener.in/screens/1/The-Bull-Cartel/")
which resulted in some java type output and it looks like this
other是 IMPORTHTML("https://www.screener.in/screens/1/The-Bull-Cartel/","table",1)
出现错误导入的内容为空".
other isIMPORTHTML("https://www.screener.in/screens/1/The-Bull-Cartel/","table",1)
which give error "imported content is empty".
推荐答案
原因 IMPORTHTML
无法导入该表是因为该表"由网站动态提供.如果您查看 https://www.screener.in/的页面源屏幕/1/The-Bull-Cartel/,您会注意到不存在 table
或 list
元素.这些元素是 IMPORTHTML
函数正常工作所必需的.
The reason IMPORTHTML
fails to import the table is because that "table" is dynamically supplied by the website. If you view the page source for https://www.screener.in/screens/1/The-Bull-Cartel/, you'll note that there are no table
or list
elements present. Those elements are required for the IMPORTHTML
function to work.
类似地, IMPORTDATA
要求您将其指向逗号或制表符分隔的文件.
Similarly, IMPORTDATA
requires you point it at a comma or tab-separated file.
您必须与网站所有者进行交流,以了解如何合法地获取他们显示的数据.
You'll have to communicate with the website owners to find out how you can legally acquire the data they display.
这篇关于如何将Javascript表导入Google电子表格?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!