新的Google Spreadsheets发布了限制 [英] New Google Spreadsheets publish limitation

问题描述

我正在测试新的Google Spreadsheets，因为我确实需要一项新功能：已解除200张限制（详情请参阅 https://support.google.com/drive/answer/3541068 ）。

但是，我无法发布电子表格到CSV就像你可以在旧版本。我去'文件>发布到网络'，并没有更多的选项发布'所有工作表'或某些工作表，你不能指定单元格范围发布到CSV等。

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

有没有其他的方法可以启用它，或者它实际上已经被排除在新版本之外？

我的用例是：我们将Bigquery结果检索到电子表格中，我们使用自动发布更新功能自动发布工作表，并生成CSV URL被放置到图表工具中，读取CSV网址以生成图像。

有人知道如何做到这一点吗？

解决方案

新的Google电子表格使用不同的网址（只需复制您的< KEY> ）：

• 新表： https://docs.google.com/spreadsheets/d /< KEY> / pubhtml


• CSV文件： https://docs.google.com/spreadsheets/d/< KEY> / export？gid =< GUID>& format = csv

您的GUID电子表格与标签号码相关。

/！\您必须使用任何有链接的人设置共享您的文档。

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).

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.

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?

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.

Does anyone know how to do this?

解决方案

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

• New sheet : https://docs.google.com/spreadsheets/d/<KEY>/pubhtml
• CSV file : https://docs.google.com/spreadsheets/d/<KEY>/export?gid=<GUID>&format=csv

The GUID of your spreadsheet relates to the tab number.

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

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