它可能不像你想要的那样直接，但这就是我如何处理它...

function main(workbook: ExcelScript.Workbook) {
    let topLeftCell = workbook.getActiveWorksheet().getCell(0, 0);
    let bottomRightCell = workbook.getActiveWorksheet().getCell(99, 9);

    workbook.getActiveWorksheet().getRange(topLeftCell.getAddress() + ":" + bottomRightCell.getAddress()).select();
}

. bottom line，使用.getCell()方法获取左上角和右下角的单元格以及相关的数字。然后，使用.getAddress()方法检索范围字符串，并将合并与.getRange()结合。

有一些选项可以引用范围。

function main(workbook: ExcelScript.Workbook) {
    let selectedSheet = workbook.getActiveWorksheet();
    // Range A1:B1
    let myRange = selectedSheet.getRangeByIndexes(0,0,1,2);
    console.log(myRange.getAddress());
    myRange = selectedSheet.getCell(0,0).getAbsoluteResizedRange(1,2);
    console.log(myRange.getAddress());
    myRange = selectedSheet.getCell(0,0).getResizedRange(0,1);
    console.log(myRange.getAddress());
    let startCell = selectedSheet.getCell(0, 0).getAddress();
    let endCell = selectedSheet.getCell(0, 1).getAddress();
    myRange = selectedSheet.getRange(`${startCell}:${endCell}`);
    console.log(myRange.getAddress());

    // Range AX:AY
    let startCol:string = "AX";
    let endCol:string = "AY";
    myRange = selectedSheet.getRange(`${startCol}:${endCol}`);
    console.log(myRange.getAddress());
    myRange = selectedSheet.getRange(startCol + ":" +endCol);
    console.log(myRange.getAddress());
}