您无权调用AppendRow [英] You do not have permission to call AppendRow

问题描述

所以我对JS和Google脚本一般都很陌生，我一直试图测试一些示例，但是当我尝试添加一行时，它说我没有权限这样做。

我读了其他一些问题，说自定义函数没有编辑其他行的权限，但如果他们有一个自定义函数完成这些操作在教程中，因为它是一个绑定脚本（通过单击脚本编辑器创建），我认为它应该具有所有权限设置。

解决方案

在Google Apps脚本和Google表格的上下文中，脚本和自定义功能不一样。

脚本是一个更广泛的概念，包含自定义函数概念。脚本是任何函数声明的结尾用户程序员/开发人员使用Google Apps脚本进行编写。 自定义功能是一种脚本，将以电子表格公式的方式调用，与Google Sheets内置函数的调用方式相同，但它们有局限性， t插入行。

So I'm pretty new to JS and Google scripts in general and I've been trying to test some of the Examples they have, however when I try to append a row it says I don't have permission to do so.

I read some other questions saying that custom functions don't have permission to edit other rows, but that wouldn't make sense if they have a custom function doing exactly that on the tutorial, since it's a bound script (created by clicking on script editor) I assume it should have all permissions set.

解决方案

In the context of Google Apps Script and Google Sheets, scripts and custom functions are not the same.

A script is a broader concept that includes the custom function concept. A script is any function statement that a end-user programmer / developer writes by using Google Apps Script. A custom function is a script that will be called from a spreadsheet formula in the same way that Google Sheets built-in functions are being called but they have limitations like they can't insert rows.

这篇关于您无权调用AppendRow的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！