def get_last_row(sheet_object) -> int:
    """
    Get the last populated row from a spreadsheet
    :param sheet_object: openpyxl worksheet
    :return: int, index of the last row
    """
    max_row_index = sheet_object.max_row
    while max_row_index > 1:
        if sheet_object.cell(max_row_index, column=1).value is None:
            max_row_index -= 1
        else:
            break
    return max_row_index