[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

GrapeCity.Documents.Excel.IRange.Insert

Insert Method

Insert(InsertShiftDirection)

Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space.

Declaration
void Insert(InsertShiftDirection shiftDirection = InsertShiftDirection.Auto)
Sub Insert(Optional shiftDirection As InsertShiftDirection = InsertShiftDirection.Auto)
Parameters
Type Name Description
InsertShiftDirection shiftDirection

Specifies which way to shift the cells.
Examples
worksheet.Range["A1"].Value = "First";
worksheet.Range["A1"].Insert();
object value = worksheet.Range["A2"].Value;