如何从Google表格获取评论 [英] How to GetComments from google sheets

问题描述

我想在脚本程序中基于单元格范围从Google工作表中获取评论，但发现range.getComment()方法已弃用，现在仅返回注释.

I want to get comments from google sheets based on cell range in my script program But found that range.getComment() method is deprecated and now returning notes only.

请让我知道getComment()方法的替代品是什么，或者在我的脚本程序中从Google工作表中获取评论的其他方法是什么?

Please let me know what is the replacement of getComment() method or what are the other ways to get comments from google sheet in my script program?

推荐答案

不幸的是，看起来Google Apps脚本只能从某个范围中检索注释:

Unfortunately, it looks like Google Apps Script can only retrieve the notes from a range:

https://developers.google.com/apps -script/reference/spreadsheet/range#getNotes()

没有等效的getComments()函数.

There is no equivalent getComments() function.

此问题已在此处正式提出:

This is an issue that has been officially raised here: https://code.google.com/p/google-apps-script-issues/issues/detail?id=1818

其中一位开发人员指出:

One of the developers has noted that:

我们知道此功能的需求，但目前尚无任何工作.作为部分解决方案，您可以使用Drive Advanced Service读取所有评论并在电子表格上答复，但是您无法创建新评论或确定给定评论附加到哪个单元格.

We are aware of the demand for this feature, but there is no work going on at the moment. As a partial solution, you can use the Drive Advanced Service to read all the comments and replied on a spreadsheet, but you aren't able to create new comments or determine to which cell a given comment is attached to.

因此可以获取所有注释，而不必获取与这些注释关联的单元格.

So it is possible to grab all comments, just not which cells those comments are associated with.

这篇关于如何从Google表格获取评论的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！