Issue in For each excel row activity

[monishanair2010 (Monisha)]

Hi

I am using a for each excel row activity to loop through the excel , based on condition I need to filter a column and do some actions and update value in specific column.

Excel has does not have a specific header name , so I am specifying the column with index 0 as given in the screenshot but I am facing an error,
could you please assist what I am doing wrong ?

[ppr (Peter Preuss)]

Give a try at:

CurrentRow.ByField("ColNAme").toString
Or
CurrentRow.ByIndex(0).toString

[Parvathy (PS Parvathy)]

Hi @monishanair2010

Try the below syntax:
CurrentRow.ByIndex(0).ToString

Let me if you have any queries.

Regards

[monishanair2010 (Monisha)]

Thank you, it worked