Comparing two excel sheet columns in asp.net web application in c#.net

Question

I want to make a asp.net web application in c#.net in which i can upload two excel sheets and after that asp.net web application should highlight the unmatched rows. Sorry, if I am asking too much, but Iam new and don't know how to start.

Community · Accepted Answer · 2017-05-23 10:32:07Z

1

You can stat with ADO.Net where you can easily read the excel file.
And after reading the excel file you can put them in data table or some collection an you can compare them.

Few helpful links
Reading Excel files from C#
http://blog.lab49.com/archives/196

Few link to compare DataTables
Compare two DataTables and select the rows that are not present in second table
http://canlu.blogspot.in/2009/05/how-to-compare-two-datatables-in-adonet.html

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Jul 3, 2013 at 12:13

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Comparing two excel sheet columns in asp.net web application in c#.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related