在您的情况下,以下示例脚本怎么样?
function myFunction() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const [sheet1, sheet2] = ["Sheet1", "Sheet2"].map(s => ss.getSheetByName(s));
const lastRowSheet1 = sheet1.getLastRow();
const sheet1Obj = sheet1.getRange("A2:B" + lastRowSheet1).getValues().reduce((o, [a]) => (o[a] = true, o), {});
const sheet2Values = sheet2.getRange("A1:A" + sheet2.getLastRow()).getValues();
const values = sheet2Values.filter(([a]) => !sheet1Obj[a]);
if (values.length == 0) return;
sheet1.getRange(lastRowSheet1 + 1, 1, values.length, 1).setValues(values);
}
["Sheet1", "Sheet2"]
.本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句