How to update values in excel column

[sruthesanju (Sweety)]

I have an excel.if the column B2 ,C2 are filled with values I need to update the input value in D2 same vice if the column B2 C2 D2 is filled I need to update in WE .can you help me to solve this

[GreenTea]

Hi @sruthesanju

Depending on your Use Case. the simple answer is

1. to Read Cell activity for B2
2. Assign Boolean variable that checks for cell B2 contains Null or Empty (String.IsNullOrEmpty([cell B2 variable]))
3. Repeat for cell C2
4. If activity to compare B2 and C2 and Write Cell to D2

[sruthesanju (Sweety)]

Can you make it dynamic ,check the column is empty or not because I can’t check each and every column because I need to check B2 to AA1

[Manish540 (Manish Shettigar)]

Can you send the sample input file and output file(like how output should be…)? @sruthesanju

[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.