Excel Online Script to loop through rows

MD_Wahib 

As variant, if for such table

to remove rows with "a" in any cell, it could be

function main(workbook: ExcelScript.Workbook) {

    const tbl = workbook
        .getTable("Table1")
    const rng = tbl
        .getRangeBetweenHeaderAndTotal()
    const value = "a"
    const values = rng
        .getValues()

    let id = -1;
    for (let row of values ) {
        let deleteRow = false;

        for (let cell of row) {
            if (cell.toString() == value) {
                deleteRow = true
            }
        }
        ++id
        if (deleteRow) { tbl.deleteRowsAt(id, 1); --id} 
    }
}

Result is