How to check the header names of excel

[Apchu (shirin sebatina)]

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

[TastyToast (Hans Muster)]

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:
IF:
myDataTable.Columns.Count = 5

[Apchu (shirin sebatina)]

Thankyou So much , it worked

Cheers