Compare the data of one excel file with another excel file?

Hi Suthish,

I know how to load excel data into DataSet.

But i need comparison.

 Load your excel into dataset using oledb

 using System.Data; 
 using System.Data.OleDb; 
  
 String sConnectionString = "OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
  

 OleDbConnection objConn = new OleDbConnection(sConnectionString); 
  
 objConn.Open(); 
  
 OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
  
 OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(); 
  
 objAdapter1.SelectCommand = objCmdSelect; 
  
 DataSet objDataset1 = new DataSet(); 
  
 objAdapter1.Fill(objDataset1); 
  
 objConn.Close();


 For connection string..

 http://www.connectionstrings.com/excel

                                                                     
                               Excel_1                                                                                 Excel_2


Want to compare "Abs" column values of Excel_1 starting from A16 (nm 200.0) with "Abs" column values of Excel_2 starting from A16 (nm 200.0).

If some set of "Abs" values of Excel_1 matches with Excel_2 , then i want to display Excel_2 file as a output.