c# with excel database

Hi,

 

Check the following example :

 

https://support.office.com/en-us/article/Basic-tasks-in-Spreadsheet-Compare-f2b20af8-a6d3-4780-8011-f15b3229f5d8?CorrelationId=7bbbd373-7c6f-4367-a763-dc12f1c07ac3&ui=en-US&rs=en-US&ad=US

 

https://social.msdn.microsoft.com/Forums/office/en-US/0e0a592f-0aeb-47eb-943b-729dfa485c18/compare-cells-in-excel-and-highlight-the-cells-that-are-different?forum=exceldev 

It's not a actual answer but will help you to read the Excel file

 

DialogResult result = openFileDialog1.ShowDialog();
if (result == DialogResult.OK)
{
try
{
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook workBook = excel.Workbooks.Open(openFileDialog1.FileNames[0].ToString());
Microsoft.Office.Interop.Excel.Worksheet sheet = workBook.Worksheets.get_Item(1);// .ActiveSheet;
Microsoft.Office.Interop.Excel.Range range = sheet.UsedRange;
string address = range.get_Address();
//string[] cells = address.Split(new char[] { ':' });
//string beginCell = cells[0].Replace("$", "");
//string endCell = cells[1].Replace("$", "");
//int lastColumn = range.Columns.Count;
int lastRow = range.Rows.Count;
// MessageBox.Show("Col "+lastColumn+", Row"+ lastRow);
workBook.Close(true);
excel.Quit();

}
catch (Exception ex)
{
MessageBox.Show(ex.toString());

}
}

 

Using Above code open two Excel file and compare the no of Rows and columns

Hi,

 

Why dont u use dataSet for the same.

 

Add both excel as table one and table two in that then u can compare two datatable.