how to find the excel value from row, col names in python?

Question

I am working on .xlsx using python & I am using openpyxl for the same.

I have the column name and row number. Can I find the value of that box from xlsx?

for example :

column - P   
row - 369

Can I find the value from Pth column & 369th row of xlsx ?

ChrisP · Accepted Answer · 2012-03-09 12:10:25Z

3

How about:

d = ws.cell(row = 4, column = 2)
print d.value

answered Mar 9, 2012 at 12:10

ChrisP

5,9721 gold badge36 silver badges36 bronze badges

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

1 Comment

The documentation also mentions you can do ws.cell('P369').