Google Spreadsheet ImportHTML表 [英] Google Spreadsheet ImportHTML table

问题描述

我想从该网站导入表格:

I want to import the table from this website:

https://www.arcgis.com/home/item.html?id=917fc37a709542548cc3be077a786c17#data

in this Spreadsheet:

https://docs.google.com/spreadsheets/d/13bfnQP_kgFsB7k3F_6xMxkMI4wW7ukI9TVq-aVZ3TzE/edit#gid=0

and used this function

=IMPORTHTML("https://www.arcgis.com/home/item.html?id=917fc37a709542548cc3be077a786c17#data", "table", 1)

The answer is "Imported content is empty". What else do I have to do?

解决方案

Alternate option. Use a custom script to load directly the JSON data.

The script to import JSON data with GoogleSheets (credits to Paul Gambill) : https://gist.github.com/paulgambill/cacd19da95a1421d3164

And the data :

https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_Landkreisdaten/FeatureServer/0/query?f=json&where=1=1&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&orderByFields=OBJECTID%20ASC&resultOffset=0&resultRecordCount=412

Output :

这篇关于Google Spreadsheet ImportHTML表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！