Google Sheet gviz csv 导出 - 两列标签未导出
我正在尝试将此工作表导出到使用以下链接在网络地图中使用 csv： https://docs.google.com/spreadsheets/d/1XQnp7RK-Ddq4wCjpHjmcnVEKood1U08kIfRGr8sDRoU/gviz/tq?tqx=out:csv&sheet=Sheet1
它运行良好，除了两个列标题 (纬度、经度）未导出，并且 csv 中的列标签为空白。我尝试将单元格的格式从“自动”更改为“纯文本”，但这并没有解决问题。
I'm trying to export this Sheet to a csv for use in a webmap using this link:
https://docs.google.com/spreadsheets/d/1XQnp7RK-Ddq4wCjpHjmcnVEKood1U08kIfRGr8sDRoU/gviz/tq?tqx=out:csv&sheet=Sheet1
It works well, except that two of the column headers (lat, long) are not exporting and the column labels in the csv are blank. I tried to change the format of the cell from Automatic to Plain text, but that didn't fix it.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
调查结果
这似乎是
gviz api的问题，因为有一个正在进行的 Google 问题跟踪器有关此问题的报告。您可能需要单击问题报告页面左上角的星号图标，以表明您也受到此问题的影响。更新
作为替代解决方案，您可以尝试这种方式，因为这将导出相同的 csv 文件：
https://docs.google.com/spreadsheets/d/1XQnp7RK-Ddq4wCjpHjmcnVEKood1U08kIfRGr8sDRoU/export?format=csv&gid=0
参考：
Google 电子表格 CSV 导出的下载链接
测试
我做了一些快速测试从 Google Sheet UI & 手动下载工作表文件作为逗号分隔值 (CSV) 文件使用替代解决方案后，不存在丢失单元格的问题。但使用
gviz api链接时，会出现问题：Findings
It seems this is an issue with
gviz apias there's an ongoing Google Issue tracker report about it. You may want to click the star icon on the top left of issue report page to indicate that your are also affected by this issue.UPDATE
As an alternative solution, you may try this way as this will export the same csv file:
https://docs.google.com/spreadsheets/d/1XQnp7RK-Ddq4wCjpHjmcnVEKood1U08kIfRGr8sDRoU/export?format=csv&gid=0
Reference:
Download link for Google Spreadsheets CSV export
Test
I did some quick tests on my end & after manually downloading the sheet file as a Comma Separated Values (CSV) file from the Google Sheet UI & after using the alternative solution, there's no issue with missing cells. But when using the
gviz apilink, the issue occurs:如果您在格式菜单 > 下将该列设置为“纯文本”数字，您应该在导出时收到数据。
If you set the column to 'Plain text' under the Format menu > Number, you should receive the data upon export.