How to check the header names of excel

Hi ,

I am trying to Validate the header in the excel if they are correct as i want them.
Can any one help me out.

firstly i need to check if i have all these headers and then proceed with my further execution

Excel Application Scope > Add Headers > output “myDataTable”

If Activity Condition : myDataTable.Columns(0).ToString.Equals(“Name”)

If you want to check them all at once you can chain the condition with OR or AND:

myDataTable.Columns(0).ToString.Equals(“Name”) AND myDataTable.Columns(1).ToString.Equals(“Class”)…

If you just want to check the amount and not the names you can simply:
myDataTable.Columns.Count = 5

1 Like

Thankyou So much , it worked :slight_smile:


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.