如何使用Javascript删除工作表中最近3天的数据？

// 步骤1：获取当前日期
var currentDate = new Date();

// 步骤2：计算最近3天的日期
var threeDaysAgo = new Date(currentDate.getTime() - 3 * 24 * 60 * 60 * 1000);

// 步骤3：筛选数据并删除
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lastRow = sheet.getLastRow();
var dataRange = sheet.getRange(1, 1, lastRow, sheet.getLastColumn());
var data = dataRange.getValues();

for (var i = data.length - 1; i >= 0; i--) {
  var rowData = data[i];
  var rowDate = new Date(rowData[0]); // 假设日期数据在第一列
  if (rowDate >= threeDaysAgo && rowDate <= currentDate) {
    sheet.deleteRow(i + 1);
  }
}