使用谷歌应用程序脚本保护范围 [英] Protect ranges with google apps script

问题描述

我有许多需要保护的纸张，但某些范围除外.

I have a number of sheets which I need to protect except for certain ranges.

是否可以使用脚本来执行此操作，因为我有几张工作表以及工作表中的许多范围，我需要取消保护以便工作人员可以编辑工作表.

Is it possible to do this with a script, as I have several sheets, and many ranges within the sheet which I need to be unprotected so staff can edit the sheets.

我需要不受保护的范围是重复的，所以我希望这是可行的.我将在我给你的示例表上用黄色填充我想保持不受保护的范围.

The ranges I need to leave unprotected are repetitive, so I'm hoping it's doable. I will fill the ranges I want to remain UNPROTECTED with YELLOW on the example sheet I'll give you.

可以查看其中一张工作表的示例 这里.

An example of one of the sheets can be viewed here.

如前所述，我需要保护整张纸，除了这些范围......

As mentioned, I need to protect the whole sheet, apart from these ranges...

N4:V26、N30:V52、N56:V78 等.基本上，纸张的其余部分需要保护.未受保护的范围，列保持不变，但每个未受保护的范围由受保护的三行分隔.

N4:V26,N30:V52,N56:V78 etc etc. Basically the rest of the sheet needs to be protected. The unprotected ranges, the columns stay the same, but each unprotected range is separated by three rows which are protected.

如果有人可以帮助使用此脚本，我将不胜感激，因为它可以为我节省数小时的时间来手动保护多个工作表的这些范围.

If anyone can help with this script I'd be very grateful as it will save me hours of time manually protecting these ranges over many sheets.

问候马特

推荐答案

是的，您可以使用 Protection 类来完成此操作.您将首先使用 var protection = sheet.protect() 保护整个工作表，然后使用 protection.setUnprotectedRanges([ranges]) 取消保护您希望人们能够编辑的范围code>，其中 [ranges] 是一个范围对象数组.您可以在 Google Apps 脚本类保护文档中阅读更多相关信息.

Yes, you can accomplish this using the Protection class. You would first protect the whole sheet using var protection = sheet.protect(), then unprotect the ranges you want people to be able to edit using protection.setUnprotectedRanges([ranges]), where [ranges] is an array of range objects. You can read more about it in the Google Apps Script Class Protection documentation.

这篇关于使用谷歌应用程序脚本保护范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！