问Google脚本:将单元格更新为文件名

EN

function onEdit(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var ssName = ss.getName();
  ss.getRange('A1:A1').setValue(ssName);  //change A1:A1 to whatever cell you would like
}

var workBookName = SpreadsheetApp.getActiveSpreadsheet().getName();
var someVariableName = sheet.getRange("G3").getValue();

var newWorkbookName = sheet.getRange("F3").getValue() + "_ConcatString_" + someVariableName // if you want to concat some values
Logger.log(workBookName);
Logger.log(newWorkbookName);
if (newName.toString().length>0 && workBookName !== newWorkbookName) {
  workBook.rename(newWorkbookName);
}

function onOpen(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  sheet.getRange("A1").setValue(ss.getName());  
}