I have a csv file that I am loading into a datatable to process. Before processing, I want to verify the column headers against a template I will have stored. I see lots of ways for comparing Excel files / datatables but I just want to verify the headers of the incoming csv first to make sure nothin…

No u dont need to loop u can simply compare them with this dt1.Columns(0).ToString=dt2.Columns(0).ToString

Comparing Column Headers

Pradeep_Shiv (Pradeep Shiv) February 23, 2020, 1:41pm 2

you can have look at this post
cheers @Chris_Livesay

1 Like

Topic		Replies	Views
Compare two Excel tables Help datatable , excel , activities	5	2143	May 15, 2018
Compare 2 datatable Headers to get matched columns from Datatable 2 Help datatable , excel , activities	12	1740	August 4, 2020
How to validate headers of an excel file (.xlsx), if they are correct or not? Studio	3	3188	May 23, 2020
Comparing two excel file Help excel	3	3069	March 22, 2018
Compare columns between two excel files and write values accordingly Studio	13	477	June 16, 2023