我只想从googlesheets的rest url中得到一行。在
当我尝试的时候
=IMPORTDATA("https://imageryuploader.geoplatform.gov/arcgis/rest/services/ImageEvents/MapServer/1/query?text=A0016-4646&outFields=EXIFPhotoDate")
我得到了页面的整个代码块
我为=IMPORTHTML("https://imageryuploader.geoplatform.gov/arcgis/rest/services/ImageEvents/MapServer/1/query?text=A0016-4646&outFields=EXIFPhotoDate", "list",1)
得到NA
如果我把https://imageryuploader.geoplatform.gov/arcgis/rest/services/ImageEvents/MapServer/1/query?text=A0016-4646&outFields=EXIFPhotoDate
进入浏览器
records: 2
EXIFPhotoDate: 1506173228000 Point: X: -66.61147999999997 Y: 18.279028333000042
EXIFPhotoDate: 1506173228000 Point: X: -66.61147999999997 Y: 18.279028333000042
我想创建一个谷歌工作表
A列-图像名称, 在B列中,它使用=IMPORTHTML(“https://imageryuploader.geoplatform.gov/arcgis/rest/services/ImageEvents/MapServer/1/query?text=A0016-4646&outFields=EXIFPhotoDate”,“list”,1)或类似的东西,得到UNIX的D/T。 最后,在C列中,它应该在dd/mm/yyyy和D中输入24 UTC时间。在
感谢Convert Exif date to different format我有了转换unix d/t的公式
如果googlesheets做不到这一点,可以使用EXCEL或python2.7
示例GSheet位于https://docs.google.com/spreadsheets/d/1Ff-gohRIkumpxqSeEVKyGq6PPEP542PJSB1vBIzI1jA/edit#gid=0
您是否安装或使用过googlesheets API?
https://developers.google.com/sheets/api/quickstart/python
这里提供了一些示例代码。在
这是GitHub链接
https://github.com/kurtlocker/sheets-api
希望有帮助。在
相关问题 更多 >
编程相关推荐