Using C#.Net windows application, I need to browse one excel file and compare the sheet columns

Question

Hi Everybody,

Can you help me to give some solution for below case.

Using C#.Net windows application, I need to browse one excel file and compare the sheet columns.

 

Ex. Sheet 1: column: A ID

 

A ID

110010

11002

110006

 

 

Sheet 2: column: A1 ID

A1 ID

110010

110004

110006

 

So I need to compare sheet2 values with sheet 1, If the value not there in sheet2 but present in sheet 1 I need to highlight that cell using c#.net coding in win. application..

 

Hope you can understand and please reply soon. any info. needed reply me back.

 

Thank you very much.

 

Regards

User