Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)

Dataslice
Dataslice
139.5 هزار بار بازدید - 4 سال پیش - Web Scrape in Google Sheets:
Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
Part 2: Web Scrape in Google Sheets: IMPORTXM...
----------------
Code
----------------
Tables: var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });
Lists: var i = 1; [].forEach.call(document.querySelectorAll('ul,ol'), function(x) { console.log(i++, x); });

----------------
Datasets
----------------
Apple Species: https://en.wikipedia.org/wiki/List_of...
Earthquakes: https://en.wikipedia.org/wiki/Lists_o...
Zha Jiang Mian Recipe: https://www.thespruceeats.com/zhajian...
Github CSV: https://github.com/datasets/populatio...
NASA RSS Feed: https://www.nasa.gov/content/nasa-rss...

----------------
Timeline
----------------
0:00 Intro
0:36 ImportHTML
4:54 ImportDATA
5:46 ImportFEED
5:59 Summary
4 سال پیش در تاریخ 1399/04/31 منتشر شده است.
139,591 بـار بازدید شده
... بیشتر