Compare headers of two excel

Help Activities
, ,
1

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)

2

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

3

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

image
image1030×511 23.7 KB

@Dinesh_Babu_S

1 Like
4

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!!

1 Like
5

This solution also worked .
Thank you.

1 Like
6

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

7

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

1 Like
8

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