c# with excel database

Question

how to compare two excel file . the excel cell is based and highlight the difference. example excle file sheet1 cell1 red green yellow cell2 green black yellow excle file sheet2 cell1 red green Black cell2 green red yellow compare two sheet and highlight the difference o/p excle file sheet2 cell1 red green Black cell2 green red yellow

Rajeesh Menoth · Answer

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

kumar yoga · Answer

thanks this is my task how to compare two excel sheet .excel sheet having row based cell. find diff and highlight the diff in row based cell diff using c# windows example sheet 1=singlecell ----Apple Orange Ball sheet 2=singlecell ----Apple Orange Graphes output

kumar yoga · Answer

thanks prem.single cell have rowbaseddata. i have to compare TWO ROW BASED CELL

Prem Anandh J · Answer

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

kumar yoga · Answer

already i use data table and use linq query and return diffrece but i want highlight the diffrence .single cell have multiple line.which line is diff in another sheet

Nishant Mittal · Answer

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.

c# with excel database

Answers (6)