在Google Apps脚本中编辑来自另一个电子表格的电子表格

function editAnotherSpreadsheet() {
  var sourceSpreadsheetId = "source_spreadsheet_id";
  var sourceSheetName = "source_sheet_name";
  var targetSpreadsheetId = "target_spreadsheet_id";
  var targetSheetName = "target_sheet_name";
  
  var sourceSpreadsheet = SpreadsheetApp.openById(sourceSpreadsheetId);
  var sourceSheet = sourceSpreadsheet.getSheetByName(sourceSheetName);
  var sourceData = sourceSheet.getDataRange().getValues();
  
  var targetSpreadsheet = SpreadsheetApp.openById(targetSpreadsheetId);
  var targetSheet = targetSpreadsheet.getSheetByName(targetSheetName);
  
  targetSheet.clearContents(); // 清空目标表格内容
  
  targetSheet.getRange(1, 1, sourceData.length, sourceData[0].length).setValues(sourceData);
}