Hi,
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.
Convert.ToChar(65+DTTest.Columns.IndexOf(“Column Name”))
So, how to get the Range till end of the excel. Eg: How to get Range “AB1” by Column Name - “Home”