How to update values in excel column

[GreenTea]

Hi @sruthesanju

Please see this post on how to convert column number to column name (e.g. AA to 27)

Convert Excel column letter to index

Hi, I need to convert excel column letter to index value. suppose column letter is AA, index value should be 27.

How to find out the column index of excel if I have Column name

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” [image]

You also need to convert Excel column name to column index (e.g. 26 to Z) to get the next column by incrementing the column index.