Excel scripting in JS : enhance getRange adress format resolution

nicolaspavie 

As variant to select from A2 to end of the column

function main(workbook: ExcelScript.Workbook) {

    const sheet = workbook.getActiveWorksheet()
    const column = sheet.getRange("A:A")
    const cell = sheet.getRange("A2")

    const range = cell
        .getResizedRange(
            column.getRowCount() - cell.getRowIndex() -1,
            0)

    console.log(range.getRowCount())

}

In general range could be selected not only by addresses - getUsedRange(), getRangeByIndexes() plus resizings, etc.

I'd avoid selecting of entire cell or row, most probably it will be negatively affect performance.