Excel Data Values Change

Else If row.Columns.Contains("Email ")

  • Then Assign row.item("Email ").ToString

Else if row.Columns.Contains(“Email 2”)

  • Then Assign row.item(“Email 2”).ToString

Else

  • Throw “email column not found”

Note that I respected the extra space you have after Email, not sure if that was intentional.

1 Like