Excel Data Values Change

Use Try Catch Block

in the Try

Assign Email - row.Item(“Email”).ToString

In the catch block

Assign Email =row.Item(“Email 2”).ToString

Irrespective of the column name - this should work

Check and let me know if you are facing any challenge

1 Like