以编程方式获得电子表格“在Web上发布[编辑] [英] Programmatically get a Spreadsheet "Publish[ed] on the web"

问题描述

暂时我相信这是一个真正的墙，我打我的头，但让我们尝试：

有没有什么办法以编程方式设置电子表格通过GAS或使用任何Google API（Google Spreadsheets，Google Docs List等）和UrlFetch来在网上发布？

目标是匿名访问工作表。

请注意，可以制作公开表格（通过Google文档列表：这是一个共享选项），或者使用GAS setAnonymousAccess（）我认为，但据我所知，不是发布，这是一杯不同的茶（它通过文件 - >在网上发布手动设置）。一个公共表没有提要，一个发布的表（它甚至不需要公开）有一个。

谢谢。

解决方案

您可以使用Drive API执行此操作，请参阅：

https://developers.google.com/drive/v2/reference/revisions

For the time being I believe this is a real wall I'm hitting my head on, but let's try:

Is there any way to programmatically set a spreadsheet to "Publish[ed] on the web" via GAS, or using any of the Google APIs (Google Spreadsheets, Google Docs List, etc.) and UrlFetch?

The goal is to access the sheet feed anonymously.

Please note that it is possible to make a sheet "public" (through the Google Docs List: it's a "sharing" option), or using GAS setAnonymousAccess() I think, but as far as I know, not "published", which is a different cup of tea (it's set manually through "File->Publish on the Web"). A "public" sheet has no feed, and a "published" one (it does not even need to be "public") has one.

Thanks.

解决方案

You can do this using the Drive API see:

https://developers.google.com/drive/v2/reference/revisions

这篇关于以编程方式获得电子表格“在Web上发布[编辑]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！