Reports

You can access rows separately and apply a replace only to each row, respectively:

workbook = Workbook('test.xlsx')

def replace_in_row(worksheet, row, old_value, new_value):
    for cell in worksheet.getCells().getRows().get(row):
        if old_value in str(cell.getValue()):
            cell.setValue(str(cell.getValue()).replace(old_value, new_value))

worksheet = workbook.getWorksheets().get(0)
replace_in_row(worksheet, 0, "one", "two")
replace_in_row(worksheet, 9, "one", "five")

or alternatively - adding to @MahrezBenHamad's answer - determine the column range and

max_column = worksheet.getCells().getMaxColumn()

worksheet.getCells().replace("one", "two", ReplaceOptions(), CellArea(0, 0, 0, max_column))
worksheet.getCells().replace("one", "five", ReplaceOptions(), CellArea(9, 0, 9, max_column))

79623389