Insert And Delete Cell Ranges | Document Solutions for Excel, .NET Edition

Insert And Delete Cell Ranges

In This Topic

DsExcel 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

DsExcel 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.

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

Method	Description
Insert	This method automatically inserts a cell or a range of cells.
Insert(InsertShiftDirection.Down)	This method inserts the range of cells and shifts the existing range of cells in downward direction.
Insert(InsertShiftDirection.Right)	This method insert the range of cells and shifts the existing range of cells to the right.

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

C#	Copy Code
//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.

C#	Copy Code
//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

DsExcel 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.

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

Method	Description
Delete	This method automatically deletes a cell or the range of cells.
Delete(DeleteShiftDirection.Left)	This method deletes the range of cells and moves the existing range of cells to the left.
Delete(DeleteShiftDirection.Up)	This method delete the range of cells and move the existing range of cells in upward direction.

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

C#	Copy Code
//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.

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