如何将Javascript表导入Google电子表格? [英] How to import Javascript tables into Google spreadsheet?

问题描述

我要在" 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电子表格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！