Google Script Apps -将单元格中输入字符串的每个单词的第一个字母大写

function capitalizeFirstLetter() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getActiveRange();
  var values = range.getValues();

  for (var i = 0; i < values.length; i++) {
    for (var j = 0; j < values[i].length; j++) {
      var words = values[i][j].split(" ");
      for (var k = 0; k < words.length; k++) {
        words[k] = words[k].charAt(0).toUpperCase() + words[k].slice(1);
      }
      values[i][j] = words.join(" ");
    }
  }

  range.setValues(values);
}