新的 Google 电子表格发布限制 [英] New Google Spreadsheets publish limitation

问题描述

我正在测试新的 Google 电子表格，因为有一项我真正需要的新功能:已取消 200 页的限制(更多信息请访问:https://support.google.com/drive/answer/3541068).

I am testing the new Google Spreadsheets as there is a new feature I really need: the 200 sheets limit has been lifted (more info here: https://support.google.com/drive/answer/3541068).

但是，我无法像在旧版本中那样将电子表格发布为 CSV.我转到文件>发布到网络"，没有更多选项可以发布所有工作表"或某些工作表，并且您无法指定要发布到 CSV 等的单元格范围.

However, I can't publish a spreadsheet to CSV like you can in the old version. I go to 'File>Publish to the web' and there is no more options to publish 'all sheets' or certain sheets and you can't specify cell ranges to publish to CSV etc.

已发布的不受支持的功能"文档中未提及此限制:https://support.google.com/drive/answer/3543688

This limitation is not mentioned in the published 'Unsupported Features' documentation found at: https://support.google.com/drive/answer/3543688

是否有其他方式启用此功能，或者它实际上已被排除在新版本之外?

Is there some other way this gets enabled or has it in fact been left out of the new version?

我的用例是:我们将 Bigquery 结果检索到电子表格中，我们使用更新时自动发布"功能将工作表自动发布为 CSV，然后生成 CSV URL，该 URL 被放置到图表工具中，读取 CSV URL生成视觉效果.

My use case is: we retrieve Bigquery results into the spreadsheets, we publish the sheets as a CSV automatically using the "publish automatically on update" feature which then produces the CSV URL which gets placed into charting tools that read the CSV URL to generate the visuals.

有人知道怎么做吗?

推荐答案

新的 Google 电子表格使用不同的 URL(只需复制您的 ):

The new Google spreadsheets use a different URL (just copy your <KEY>):

• 新工作表:https://docs.google.com/spreadsheets/d//pubhtml
• CSV 文件:https://docs.google.com/spreadsheets/d//export?gid=&format=csv

电子表格的 GUID 与标签编号相关.

The GUID of your spreadsheet relates to the tab number.

/! 您必须使用知道链接的任何人设置来共享您的文档.

/! You have to share your document using the Anyone with the link setting.

这篇关于新的 Google 电子表格发布限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！