I have two different Excels with same type of coloumn names but with different content in it… How can i compare the values for the coloumns between these excel sheets?
Seems like a data table comparison usecase. Do those table have at least one unique ID/Primary ID column which is constant for each row? Or is it all different?
You can user queries, or LinQ or the following suggestion - Comparing two data tables