IMPORTHTML或IMPORTXML从站点收集数据 [英] IMPORTHTML or IMPORTXML to collect data from a site

问题描述

我已经尝试过几次收集该表中的数据:

I have made several attempts to collect the data within this table:

我已经尝试过但未成功的两个功能的简单方法.

The simple ways of the two functions I've commented on, I've tried, but not succeeded.

我想知道是否有人知道以其他方式在Google表格中收集此数据.

网站链接:
https://www.onlinebettingacademy.com/stats/团队/巴西/operrio-pr/13217#tab = t_squad

Site Link:
https://www.onlinebettingacademy.com/stats/team/brazil/operrio-pr/13217#tab=t_squad

推荐答案

您要抓取的表受JavaScript控制，因此无法抓取.

the table you want to scrape is under JavaScript control, therefore, it can't be scraped.

您可以从该站点下载到Google表格中的所有内容是

all you can get from that site into Google Sheets is:

=ARRAY_CONSTRAIN(IMPORTDATA(
 "https://www.onlinebettingacademy.com/stats/team/brazil/operrio-pr/13217#tab=t_squad&team_id=13217"); 10000; 10)

这篇关于IMPORTHTML或IMPORTXML从站点收集数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！