Compare headers of two excel

[Dinesh_Babu_S]

Hello all I am trying to compare headers of two excel files dt1, dt2.
I am using below LINQ.
dt1.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName).SequenceEqual(dt2.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName))

But getting the error : If: Object reference not set to an instance of an object.

Can you guys check or give any alternative solution?
Data Validation.xaml (9.8 KB)

[Praveen_Mudhiraj]

@Dinesh_Babu_S

I am trying to compare headers of two excel files dt1, dt2.
I am using below LINQ.

can you try this

dt1.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName).SequenceEqual(dt2.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName), StringComparer.OrdinalIgnoreCase)

@Dinesh_Babu_S

[Praveen_Mudhiraj]

it will working you can try this if columns match it will output as matched or if not it will give the not matched as output

Xaml : DataValidation.zip (2.1 KB)

for reference you can see the screenshot

@Dinesh_Babu_S

[Parvathy (PS Parvathy)]

Hi @Dinesh_Babu_S

areColumnNamesEqual = dt1.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName).SequenceEqual(dt2.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName))

If areColumnNamesEqual 
Then
    Console.WriteLine("Column names are equal.")
Else
    Console.WriteLine("Column names are not equal.")
End If

Note: areColumnNamesEqual is of DataType Boolean

Hope it helps!!

[Dinesh_Babu_S]

This solution also worked .
Thank you.

[Dinesh_Babu_S]

This solution works if the position of the columns are same in both the Data tabel.
How to Handel if position is changing?

[Praveen_Mudhiraj]

if columns are same and position was different

try this it will work

dt1.Columns.Cast(Of DataColumn)().
    Select(Function(c) c.ColumnName.ToLower()).ToHashSet().SetEquals(
    dt2.Columns.Cast(Of DataColumn)().
    Select(Function(c) c.ColumnName.ToLower()))

@Dinesh_Babu_S