请试试看。

function main(workbook: ExcelScript.Workbook) {
    let selectedSheet = workbook.getActiveWorksheet();
    let table = selectedSheet.getTables()[0];
    if (table) {
        let lastCell: ExcelScript.Range = table.getRange().getColumn(0).getLastCell();
        if(! lastCell.getText()){
            let lastRow = lastCell.getRangeEdge(ExcelScript.KeyboardDirection.up);
            selectedSheet.getRange(`${lastRow.getRowIndex() + 2}:${lastCell.getRowIndex() + 1}`)
                .delete(ExcelScript.DeleteShiftDirection.up);
        }
    }
}

字符串

• Microsoft文档：*

ExcelScript.Range接口