我尝试将值从Google电子表格传递给JSON。但是我收到无效的json字符串错误。您能帮我解决我做错了什么吗?
请在下面找到代码片段
代码:
for(var i=0;i>=10;i++)
{
var userEmail = sheet.getRange(3, 2, sheet.getLastRow()).getValues();
var owner = {
email: userEmail[i],
role: 'OWNER'
};
owner = AdminDirectory.Members.insert(owner, groupEmail);
Logger.log('User %s added as a owner of group %s.', userEmail, groupEmail);
Browser.msgBox("Owner Successfully Added!");
}
var userEmail必须在for()循环之外,并且您还必须选择对象userEmail [i]的第一个值。在您的代码中,我还假定工作表var在此代码段之前的某个位置定义。
var userEmail = sheet.getRange(3, 2, sheet.getLastRow()).getValues();
for(var i in userEmail) {
var owner = {
email: userEmail[i][0],
role: 'OWNER'
};
owner = AdminDirectory.Members.insert(owner, groupEmail);
Logger.log('User %s added as a owner of group %s.', userEmail, groupEmail);
Browser.msgBox("Owner Successfully Added!");
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句