转移电子表格文件的所有权



如果用户复制文件,我试图制作下面这样的代码来转移文件所有权,但它不起的作用

function owner () {
var ss = SpreadsheetApp.getActive();
var namedRanges = SpreadsheetApp.getActiveSpreadsheet()
var name = namedRanges.getName()
var files = DriveApp.getFilesByName(name);
while (files.hasNext()) {
var file = files.next();
var lowner = file.getOwner();
var owner = lowner.getEmail();
if (owner =="my email"){
}
else {
file.setOwner("my email");
} 
}
}

function setOwner() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = SpreadsheetApp.getActiveSheet();
var files = DriveApp.getFilesByName(ss.getName());
while (files.hasNext()) {
var file = files.next();
var owner = file.setOwner("my email");
}
}

最新更新