应用程序脚本-将E列复制到另一个工作表的K列，但将常量值添加到其他列(B和D列)

function copyAndAddConstant() {
  var sourceSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("源工作表名称");
  var targetSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("目标工作表名称");
  
  var sourceRange = sourceSheet.getRange("E:E");
  var targetRange = targetSheet.getRange("K:K");
  
  var sourceValues = sourceRange.getValues();
  var targetValues = targetRange.getValues();
  
  for (var i = 0; i < sourceValues.length; i++) {
    targetValues[i][0] = sourceValues[i][0];
    targetValues[i][1] = "常量值1";
    targetValues[i][3] = "常量值2";
  }
  
  targetRange.setValues(targetValues);
}