Worksheet.DeleteCells(CellRange, DeleteMode) Method
A CellRange object specifying a cell range to be deleted from the worksheet.
A DeleteMode enumeration member specifying in which direction to shift other cells.
Use the DeleteCells method to delete the specified cell range from the worksheet.
You can delete a cell range and shift other cells in the same column up, or shift other cells in the same row to the left. You can also delete entire rows and columns that comprise the specified range of cells. In this case, other rows and columns are automatically shifted up or to the left. For more information on deleting rows and columns, refer to the How to: Delete a Row or Column from a Worksheet example.
To delete only cell content or formatting without removing entire cells from the worksheet, use the Worksheet.ClearContents, Worksheet.ClearFormats, Worksheet.ClearHyperlinks, Worksheet.ClearComments or Worksheet.Clear method (see the How to: Clear Cells of Content, Formatting, Hyperlinks and Comments example).
Another way to insert, delete and clear the cell range is to use the range's RangeExtensions.Insert, RangeExtensions.Delete and Clear* extension methods defined by the RangeExtensions class. These extension methods are accessible as methods of the CellRange object and called by using the instance method syntax.
This example demonstrates how to delete cells from a worksheet. To do this, use the Worksheet.DeleteCells method. Pass a cell or cell range that you want to delete, and the DeleteMode.ShiftCellsUp or DeleteMode.ShiftCellsLeft enumeration member to specify how to shift other cells.
using DevExpress.Spreadsheet; // ... IWorkbook workbook = spreadsheetControl1.Document; Worksheet worksheet = workbook.Worksheets; // Delete the C5 cell, shifting other cells in the same row to the left. worksheet.DeleteCells(worksheet.Cells["C5"], DeleteMode.ShiftCellsLeft); // Delete the H11:I12 range of cells, shifting other cells in the same column up. worksheet.DeleteCells(worksheet.Range["H11:I12"], DeleteMode.ShiftCellsUp);