I am using Write cell activity to write value in excel. I have Column Name, but the column may change to different place. Eg: The Column1 may in Column A or Column B in excel.
I have used the below code to get the Range of the cell with Column Name. But this is working till “Z”. From “AA” it is not returning correct index.
So, how to get the Range till end of the excel. Eg: How to get Range “AB1” by Column Name - “Home”