collect an html table from an URL into google sheet.
I have tried IMPORTHTML, IMPORTXML, AND IMPORTDATA in the google sheet, only the IMPORTDATA works. I assume it is because the table in the URL is not in csv or tsv formate.
This is the url https://www.tpex.org.tw/web/stock/historical/trading_vol_ratio/sectr_result.php?l=zh-tw&d=112/09/18&s=4,desc,0&o=htm
I used IMPORTDATA, and I get:
Is there a way to make it a table in google sheet?
One other question:
Here the date 112/09/18 will be updated by using other functions ( today(), and REGEXREPLACE) . I am just curious if I publish the table (or the figure), will it be automatically updated every time I access the link?
Posted Sep 18, 2023, 10:03 AM UTC
11