comparing two excel sheets and updating in one

Hi,

You can use OLEDB to convert excel sheet to datatable.

First upload both the sheets in store both in separate data tables.

After converting it to data table you can easily compare tables.

If you need the code to upload the excel and convert it to data table please let me know.

Hope it helps.

Thanks.

Hi

check the link

http://stackoverflow.com/questions/18452660/comparing-two-excel-files-for-differences

https://social.msdn.microsoft.com/Forums/office/en-US/fdf66ac5-070a-4d6a-abbe-4159499ad488/comparing-two-excel-files-and-writing-the-difference-into-a-new-worksheet-using-cnet?forum=exceldev

http://forums.asp.net/t/1766261.aspx?how+to+compare+2+excell+sheets+data+in+c+

http://www.dotnetfunda.com/forums/show/8429/how-can-i-compare-2-excel-sheet-data-using-aspnet-and-csharp