将粘贴单元格复制到特定范围内的空单元格- google应用程序脚本表

function copyPasteCells() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sourceSheet = spreadsheet.getSheetByName("源表格名称");
  var targetSheet = spreadsheet.getSheetByName("目标表格名称");
  
  var sourceRange = sourceSheet.getRange("源范围");
  var targetRange = targetSheet.getRange("目标范围");
  
  var sourceValues = sourceRange.getValues();
  var targetValues = targetRange.getValues();
  
  for (var i = 0; i < sourceValues.length; i++) {
    for (var j = 0; j < sourceValues[i].length; j++) {
      if (sourceValues[i][j] != "" && targetValues[i][j] == "") {
        targetRange.getCell(i+1, j+1).setValue(sourceValues[i][j]);
      }
    }
  }
}