IWorkbook workbook = spreadsheetControl.Document; Worksheet worksheet = workbook.Worksheets["Sheet1"]; CellRange range = worksheet.GetUsedRange(); int LastRow = range.BottomRowIndex; //MessageBox.Show(Convert.ToString(LastRow)); for (int i = 0; i < LastRow; i++) { for (int n = 1; n < LastRow; n++) { if (worksheet.Cells[i,0].Value == worksheet.Cells[i+n,0].Value) { worksheet.Rows[n].Delete(); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)