如何从Google云端硬盘评论API获取单元格范围 [英] How to get a cell range from Google Drive Comments API

问题描述

我试图在Google电子表格中查找评论所属的单元格.从API中获取

I am trying to find out to which cell a comment belongs to in Google Spreadsheet. From the API I get

{'kind': 'drive#comment',
   ...
   'anchor': '{"type":"workbook-range","uid":0,"range":"285502171"}',
   ...}

但是我无法将整数值range转换为电子表格中适当的单元格范围(即A1:A2).根据文档，锚点看起来应该完全不同.根据文档，我假设应该有一个类型为matrix的 region 类.首先，文档中没有提到workbook-range.

Yet I am unable to transform the integer-valued range to the appropriate cell range (i.e. A1:A2) in the spreadsheet. According to the documentation the anchor should look completely different. Based on the doc I'd assume that there is supposed to be a region class of type matrix. There is no mention of workbook-range in the doc in the first place.

推荐答案

基于此 Google Drive API中的锚定评论功能适用于非Google文档编辑器文件，而不适用于 Google文档.不幸的是，目前Google Apps脚本的文档服务不包含用于处理评论和讨论的班级评论.

The Anchoring Comments feature from the Google Drive API is intended for non-Google Docs editors files, not for Google Documents. Unfortunately, at this time the Document Service from Google Apps Script doesn't include a Class Comment to handle comments and discussions.

您可能可以使用非Google编辑器文件来做到这一点.

You could probably do this with non-Google editor files.

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