Change one word in specific row in Excel file using Python

Question

I found out how to change text in Excel file with Aspose.Cells for Python through Java:

import jpype
import asposecells
jpype.startJVM()
from asposecells.api import *

import os
os.chdir(r"c:\Users\Manager\Desktop")
os.getcwd()
workbook = Workbook('Invoice.xlsx')

# Create replace options
replace = ReplaceOptions()


# Set case sensitivity and text matching options
replace.setCaseSensitive(False)
replace.setMatchEntireCellContents(False)



# Replace text
workbook.replace("one","two", replace)
workbook.replace("one","five", replace)




workbook.save("Invoice 2.xlsx");

But I need to replace "one" in first row to "two", "one" in tenth row to "five". As you see, first replacement affects on all file. How can I fix it?

Can you give an example, as to how "Invoice.xlsx" looks like? — DuesserBaest
– DuesserBaest, Commented May 15 at 8:37
If you know the range where you want to make the replacement, you should be able to use FindOptions setRange: reference.aspose.com/cells/java/com.aspose.cells/findoptions and here's example with Python for .NET with exact thing you are doing: docs.aspose.com/cells/python-net/… — Caldazar
– Caldazar, Commented May 15 at 8:42
Modify this worksheet using Python 3.13.3.Replace workbook.replace("one","five", replace) to workbook.replace("two","five", replace) — user30412914
– user30412914, Commented May 15 at 9:53

Mahrez BenHamad · Accepted Answer · 2025-05-15 11:39:12Z

0

You can try something like this:

worksheet = workbook.getWorksheets().get(0)
worksheet.getCells().replace("one", "two", ReplaceOptions(), CellArea(0, 0, 0, 100))  # Row 1 
worksheet.getCells().replace("one", "five", ReplaceOptions(), CellArea(9, 0, 9, 100))  # Row 10

answered May 15 at 11:39

Mahrez BenHamad

2,6641 gold badge22 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

André · Accepted Answer · 2025-05-15 13:05:05Z

0

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))

answered May 15 at 13:05

André

1,98614 silver badges28 bronze badges

1 Comment

StanleyBanley86 May 20 at 13:00

I tried your first variant and it works well.

Collectives™ on Stack Overflow

Change one word in specific row in Excel file using Python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related