collect an html table from an URL into google sheet.

Unsolved

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:

https://docs.google.com/spreadsheets/d/e/2PACX-1vQwYu1v0fsMntCmYXPe4grrPa0rrASQp9liuv3InFwxE8fqNliStVeWYcihwiAvaOW7TeQC39Mm35Rj/pubhtml?gid=1633550466&single=true

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
Loading comments…