Insert And Delete Cell Ranges

GcExcel enables you to insert and delete a cell or a range of cells in order to help customization of worksheets as per your requirements.

Insert cell range

GcExcel allows you to add a cell or a range of cells in a worksheets by calling the Insert method of IRange. To add a cell or a range of cells, specify the cell range, for example A3 for single cell or A3:A5 for a range of cells.

GcExcel provides following different options to insert a cell or a range of cells.

Refer to the following example code to see how you can insert a single cell and a cell range in the worksheet.

//Insert the range of cell
worksheet.Range["A3"].Insert();

// Insert the range of cells
worksheet.Range["A3:A5"].Insert();

Refer to the following example code to see how you can insert cell range in a worksheet while specifying a direction to shift the existing cells in required direction.

//Insert the range of cells in desired direction
worksheet.Range["A3:B10"].Insert(InsertShiftDirection.Down);
worksheet.Range["A5:C5"].Insert(InsertShiftDirection.Right);

Delete cell range

GcExcel allow you to delete a cell or a range of cells in the worksheets by calling Delete method of IRange. To remove a cell or a range of cells, specify the cell range, for example B4 for a single cell or B4:C4 for a range of cells.

GcExcel provide following different options to delete a cell or range of cells.

Refer to the following example code to see how you can delete single cell or a cell range in a worksheet.

//Delete the range of cell
worksheet.Range["B4"].Delete();

// Delete the range of cells
worksheet.Range["B4:C4"].Delete();

Refer to the following example code to see how you can delete a single cell or a range of cells in a worksheet while specifying a direction to shift the existing cells in required direction.

//Delete the range of cells from desired direction
worksheet.Range["B3:C8"].Delete(DeleteShiftDirection.Left);
worksheet.Range["B5:D5"].Delete(DeleteShiftDirection.Up);