code for comparing two .xls files(excel documents) in c sharp .net

Question

Hi all I have two excel files. In each file two columns are there. In first file ID And FirstName columns are there. In second file ID And LastName columns are there. In both files ID column values are same. Now my requirement is compare those id columns in two files and replace the FirstName Column(in First File) values with SecondName Column(in Second File) values to corresponding ID's. Please post code to this..

Yonatan Sion · Answer

if you're willing to consider 3rd party The following tool will do it for you: http://nobhillsoft.com/Columbo.aspx

Suthish Nair · Answer

This not a simple task so no ready made codes to share. You can also try this with LINQ to EXCEL.

gold spoon · Answer

Please post code..

Sam Hobbs · Answer

Use the Excel object model (also known as Excel Interop) to read each spreadsheet. Create a DataSet which is an in-memory copy of data; you do not need to write the data to a database. Create two tables in the DataSet one for the data for each spreadsheet. Use a SQL query to create a union. Use the result of that to create the new spreadsheet. Alternatively you can read the data of each of the two spreadsheets into collections and then use LINQ to create the union.