Excel JavaScript API -如何选择单元格直到填充范围结束

Excel.run(function(context) {
  var sheet = context.workbook.worksheets.getActiveWorksheet();
  var startCell = sheet.getRange("A1");
  var endCell = sheet.getUsedRange().getLastCell();
  
  var startAddress = startCell.getAddress();
  var endAddress = endCell.getAddress();
  
  console.log("填充范围地址: " + startAddress + ":" + endAddress);
  
  return context.sync();
}).catch(function(error) {
  console.log(error);
});

Excel.run(function(context) {
  var sheet = context.workbook.worksheets.getActiveWorksheet();
  var startCell = sheet.getRangeByIndexes(0, 0); // 假设起始单元格是A1
  var endCell = sheet.getRangeByIndexes(sheet.usedRange.rowCount - 1, sheet.usedRange.columnCount - 1);
  
  var startAddress = startCell.getAddress();
  var endAddress = endCell.getAddress();
  
  console.log("填充范围地址: " + startAddress + ":" + endAddress);
  
  return context.sync();
}).catch(function(error) {
  console.log(error);
});