Google Apps脚本 - 函数重命名所有具有特定单元格值的表

Question

我正在使用此功能根据B4中的单元格值重命名活动表格 - 但是我想为整个电子表格进行此功能，每个纸张应重命名为B4中其自己的特定单元格值。 谁能告诉我如何用for for for for for？！thanx！

function RenameSheetsM() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet(); // active Sheet = Tab
  var cell = sheet.getRange("B4");// cell B4 = Name  
  var value = cell.getValue();//Added
  sheet.setName(value);//Sheet name changed
}

Answer 1

function RenameSheetsM() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
  for (i=0; i<sheets.length; i++) {
    var value = sheets[i].getRange("B4").getValue();
      if(sheets[i].getName() != value){
        sheets[i].setName(value);
      }    
  }
}

Answer 2

可以是这样的：

function main() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
  for (let sheet of sheets) {
    RenameSheetsM(sheet);
  }
}

function RenameSheetsM(sheet) {
  var cell = sheet.getRange("B4");// cell B4 = Name  
  var value = cell.getValue();//Added
  sheet.setName(value);//Sheet name changed
}

但是我更喜欢循环when（），它看起来很整洁：

function main() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
  while (sheets.length) {
    var sheet = sheets.shift();
    var cell = sheet.getRange("B4");
    var value = cell.getValue();
    sheet.setName(value);
  }
}

Answer 3

在电子表格中重命名所有床单

function  renameSheets() {
  SpreadsheetApp.getActive().getSheets().forEach(sh => sh.setName(sh.getRange('B4').getDisplayValue()));
}