如何使用GAS访问电子表格的修订历史记录？ [英] How to access revision history of a spreadsheet using GAS?

问题描述

是否可以直接从Google Apps脚本访问电子表格的修订历史记录数据？如果是这样，怎么做？

我想做两件事：

1. 将每个修订版记录的用户名更改为运行该脚本的实际用户，而不是脚本作者/所有者。正如我刚刚所了解的，使用GAS访问和修改的电子表格的修订历史记录总是反映脚本所有者/作者，而不是运行脚本的用户。

如果上述不可行，那么

1. 直接从历史记录直接读取修订号和用户名加油站。从那里开始，我只是做一个比较表，希望能达到同样的效果。

感谢任何洞察力。

Saban

解决方案

我不相信这是可以使用Apps脚本访问修订历史记录。这个功能有一个开放的功能要求，如果你为它加注星标，你会在有更新时收到一封电子邮件：

http://code.google.com/p/google-apps-script-问题/问题/细节？id = 394

Is it possible to access revision history data of a spreadsheet directly from Google Apps Scripts? If so, how?

I would like to do two things:

1. Change the username logged for each revision to the actual user running the script and not the script author/owner. As I've just learned, revision history of a spreadsheet that's accessed and modified using GAS always reflects the script owner/author instead of the user running the script.

If the above is not possible, then

1. Get direct read access to revision number and username in the history straight from GAS. From there, I'll just do a comparison table and hope for the best that I'll achieve the same effect.

Thanks for any insight.

Saban

解决方案

I don't believe it's possible to access the revision history with Apps Script. There is an open feature request for this ability though, and if you star it you'll receive an email when there is an update:

http://code.google.com/p/google-apps-script-issues/issues/detail?id=394

这篇关于如何使用GAS访问电子表格的修订历史记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！