如何使用Google試算表進行爬蟲

使用 importDATA 讀取 CSV 檔(成功率最高)

=importDATA("CSV_file_url")

使用 importHTML 讀取網頁表格(成功率次之)

importHTML(“https://zh.wikipedia.org/wiki/各國人均國民總收入列表”, “table”, 1)

使用 importXML 讀取任意網頁內容(難度最高)

=importXML("https://www.ptt.cc/bbs/Baseball/index.html","//*/div[2]/div/div/a")

Written by

Machine Learning / Deep Learning / Python / Flutter cakeresume.com/yanwei-liu

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store