Deleting-Ranges.md

var workbook = new XLWorkbook();

var ws = workbook.Worksheets.Add("Deleting Ranges");
foreach (var ro in Enumerable.Range(1, 10))
  foreach (var co in Enumerable.Range(1, 10))
    ws.Cell(ro, co).Value = ws.Cell(ro, co).Address.ToString();

// Delete range and shift cells up
ws.Range("B4:C5").Delete(XLShiftDeletedCells.ShiftCellsUp);

// Delete range and shift cells left
ws.Range("D1:E3").Delete(XLShiftDeletedCells.ShiftCellsLeft);

// Delete an entire row
ws.Row(5).Delete();

// Delete a row in a range, shift cells up
ws.Range("A1:C4").Row(2).Delete(XLShiftDeletedCells.ShiftCellsUp);

// Delete an entire column
ws.Column(5).Delete();

// Delete a column in a range, shift cells up
ws.Range("A1:C4").Column(2).Delete(XLShiftDeletedCells.ShiftCellsLeft);

workbook.SaveAs("DeletingRanges.xlsx");