How to get cell number of an excel using Pandas

Asked Sep 14 '21 at 06:57

Active Sep 14 '21 at 06:57

Viewed 37 times

Is there a way to access cell number of an excel cell in Pandas? I am able to access cell value by iterating over rows and columns but I want to get the cell number for that particular iteration.

Eg: A21, where A21 is the cell number, A is the column letter and 21 is the row number.

I need the column letter to pass it to hyperlink

asked Sep 14 '21 at 06:57

Us86

openpyxl is your friend for this use case – sammywemmy Sep 14 '21 at 06:57
Could you please give me an example or a sample code to refer to? – Us86 Sep 14 '21 at 07:02
Take a look at [this post](https://stackoverflow.com/questions/12902621/getting-the-row-and-column-numbers-from-coordinate-value-in-openpyxl) – SeaBean Sep 14 '21 at 07:11
Yes this get_column_number() works. Thank you – Us86 Sep 14 '21 at 07:56

How to get cell number of an excel using Pandas

0 Answers0