試算表 importhtml函數問題 - Google

By Bethany
at 2016-09-14T12:53
at 2016-09-14T12:53
Table of Contents
大家好
我想匯入yahoo股巿中的歷年股利政策至google試算表中
查了一下函數是importhtml("website", "table", 索引)
以台積電2330為例,https://tw.stock.yahoo.com/d/s/dividend_2330.html
函數應該寫成
=importhtml("https://tw.stock.yahoo.com/d/s/dividend_2330.html", "table", ?)
而我卡住的地方則是不知道索引的數字,不知道有沒有人能協助
或是提供可能的方向呢?
先謝謝大家了。
--
我想匯入yahoo股巿中的歷年股利政策至google試算表中
查了一下函數是importhtml("website", "table", 索引)
以台積電2330為例,https://tw.stock.yahoo.com/d/s/dividend_2330.html
函數應該寫成
=importhtml("https://tw.stock.yahoo.com/d/s/dividend_2330.html", "table", ?)
而我卡住的地方則是不知道索引的數字,不知道有沒有人能協助
或是提供可能的方向呢?
先謝謝大家了。
--
Tags:
Google
All Comments

By Lucy
at 2016-09-17T05:10
at 2016-09-17T05:10

By Brianna
at 2016-09-19T19:31
at 2016-09-19T19:31

By Bennie
at 2016-09-24T15:58
at 2016-09-24T15:58

By Andy
at 2016-09-24T21:32
at 2016-09-24T21:32

By Andy
at 2016-09-25T19:26
at 2016-09-25T19:26

By Gary
at 2016-09-30T13:17
at 2016-09-30T13:17

By Rachel
at 2016-10-04T12:41
at 2016-10-04T12:41
Related Posts
雲端硬碟中近期存取資料 不知名檔案過多

By Wallis
at 2016-09-12T00:57
at 2016-09-12T00:57
chrome網頁開不了 連設定都進不去

By Emily
at 2016-09-11T16:04
at 2016-09-11T16:04
Google表單根據答案前往相關區段問題

By Kelly
at 2016-09-10T20:44
at 2016-09-10T20:44
Google Maps/地圖 上傳照片未出現

By Sandy
at 2016-09-10T18:39
at 2016-09-10T18:39
請問Google雲端費用

By Carol
at 2016-09-10T17:59
at 2016-09-10T17:59