使用Google Apps脚本插入数据验证 [英] Insert Data Validation using Google Apps Script

问题描述

我试图使用Google Apps脚本在Gsheet中插入单元格下拉菜单（数据>验证>项目列表）。我想这样做是因为每次使用电子表格时，项目列表将略有变化，每次打开电子表格时，我不想去数据>验证>项目列表。

I'm trying to insert an in cell dropdown menu (Data > Validation > List of Items) in a Gsheet using Google Apps Script. I want to do this because every time I use the spreadsheet the 'list of items' will change slightly and I don't wanna have to go to "Data > Validation > List of Items" every time I open the spreadsheet.

我知道数据>验证>从范围列表存在，但我宁愿不使用它。

I'm aware that "Data > Validation > List from a Range" exists but I'd rather not use it.

推荐答案

刚刚发布的用于数据验证的Apps Script API：
http://googleappsdeveloper.blogspot.com/2013/08/answering-another-top-request-data.html

An Apps Script API for data validation was just released: http://googleappsdeveloper.blogspot.com/2013/08/answering-another-top-request-data.html

相关参考：

• 动态创建的下拉验证列表（Google Apps脚本）


• https://code.google.com/ p / google-apps-script-issues / issues / detail？id = 2958


• https://code.google.com/p/google-apps-script-issues/issues/detail?id=219

• Drop-down validation list created dynamically (google apps script)
• https://code.google.com/p/google-apps-script-issues/issues/detail?id=2958
• https://code.google.com/p/google-apps-script-issues/issues/detail?id=219

这篇关于使用Google Apps脚本插入数据验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！