How to get cell reference address from excel

[Lumjing]

Hi I have a 30000 rows of data with 120 columns. I am comparing the columns and to get the difference and when the difference is there i am flagging them. I want to get the excel cell address when the difference is found for that particular row and column example from the below table (Please find attached a sample data) Difference is found in A. I want to get the cell address like B3 and B4 is there a work way to achieve this. 

Input						Output
Record ID	A	B	Difference of A and B	Record ID	A	Column Name	Cell Address
1	10	5	5			1	10	A	B3
2	20	10	10			2	20	A	B4

[dreldrel]

Yes, you can use from openpyxl.utils import get_column_letter inside the Alteryx Python tool, and it is a clean and reliable way to generate Excel column letters.

Alteryx Python tool runs a standard Python environment, and openpyxl is supported in current Designer versions. Within the Python tool, the incoming Alteryx stream can be read as a pandas DataFrame using  Alteryx.read("#1"). You can then detect the differences using pandas logic and finally apply get_column_letter to get cell addresses