To find Python openpyxl value coordinates

I read the Excel file in openpyxl I'd like to find the cell coordinates of the value written in the excel I don't know what code to use even if I try hard to google.

python openpyxl

2023-01-02 15:24

1 Answers

By default, to use openpyxl, you can read the file, specify the sheet, and then read or specify the value in Sheet["A1"].

    excel = openpyxl.Workbook()
    sheet = excel['Sheet']

    a = "hello"
    sheet["A1"] = f"{a} world"
    print(sheet["A1"].value)

If you find the coordinate value of the cell with the value of hello world, I am not sure how to find it as a double for statement.

    excel = openpyxl.Workbook()
    sheet = excel['Sheet']

    a = "hello world"
    for i in range(1, 100):
        For j in range('A'-'ZZ'): # Col value is alphabets, so I think you need to implement this part.
            if sheet[f'{i}{j}'].value == a:
                return [i, j]

2023-01-02 22:38

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656