Google Sheets /在脚本中将行移动到其他工作表中的清除格式

function moveAndClearFormat() {
  var sourceSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var targetSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("目标工作表名称");
  
  var range = sourceSheet.getActiveRange();
  var numRows = range.getNumRows();
  var numColumns = range.getNumColumns();
  
  var values = range.getValues();
  var formats = range.getFontStyles();
  
  targetSheet.getRange(targetSheet.getLastRow() + 1, 1, numRows, numColumns).setValues(values);
  targetSheet.getRange(targetSheet.getLastRow() + 1, 1, numRows, numColumns).setFontStyles(formats);
  
  range.clear();
}