全新社群
Log in
Username or email
*
Password
*
Activity
Blogs
Bookmarks
Files
Groups
More
Members
Pages
The Wire
Videos
Bookmarks
Tim
Google 試算表結合 Google Maps,自動計算地點距離、抵達時間等資訊
0 likes
By
Tim
1533 days ago
google maps
spreadsheet
google
https://steachs.com/archives/53796
Google 試算表結合 Google Maps,自動計算地點距離、抵達時間等資訊
=GOOGLEMAPS_ADDRESS(10005):取得地址,括號裡也可以是某地標名稱
=GOOGLEMAPS_COUNTRY("Taj Mahal, Agra"):取得地點的國家,可以輸入地址、地標等
=GOOGLEMAPS_LATLONG("buckingham palace"):取得經緯度
=GOOGLEMAPS_DISTANCE("Boston", "NY"):取得地點之間的距離
=GOOGLEMAPS_DURATION("Hoboken", "NY", "walking"):取得地點之間的行程時間
=GOOGLEMAPS_REVERSEGEOCODE("37.4219999","-122.0840575"):取得該經緯度的地址
=GOOGLEMAPS_DIRECTIONS("10005", "hoboken", "bicycling"):取得地點與地點之間的行程內容
Tim
Blogs
Bookmarks
Files
Pages
Videos
Wire posts