comparing two excel sheets and updating in one

Question

hi i have two excel sheets with some data. Main sheet contains the consolidation of both sheets and it is taken for reference. if the data are changed then it should be updated as changed in conclusion column in main. how to do this it should be in c#

Vishal Jadav · Answer

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.

Vinay Singh · Answer

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