Insert() Method

Inserts rows or columns by shifting rows down or columns right and fixing up formulas and formats.

Syntax

Visual Basic
C#

'Declaration
 
Overloads Sub Insert()

'Usage
 
Dim instance As IRange
 
instance.Insert()

void Insert()

Remarks

Must be performed on entire row(s) or entire column(s).

Example

using System;
using SpreadsheetGear;
using System.Diagnostics;
             
namespace SpreadsheetGear.InsertExample
{
    class Program
    {
        static void Main()
        {
            // Create a workbook.
            IWorkbook workbook = Factory.GetWorkbook();
            IWorksheet worksheet = workbook.Worksheets[0];
            IRange cells = worksheet.Cells;
             
            // Set some text in A1:B2.
            cells["A1"].Formula = "A1";
            cells["A2"].Formula = "A2";
            cells["B1"].Formula = "B1";
            cells["B2"].Formula = "B2";
             
            // Insert two rows before row 2.
            cells["2:3"].Insert();
             
            // Insert three columns before column 'B'.
            cells["B:D"].Insert();
             
            // Verify new locations - A1 has not moved.
            Debug.Assert(cells["A1"].Formula.Equals("A1"));
            // A2 has been moved down two rows.
            Debug.Assert(cells["A4"].Formula.Equals("A2"));
            // B1 has been moved right three columns.
            Debug.Assert(cells["E1"].Formula.Equals("B1"));
            // B2 has been moved down two rows and right three columns.
            Debug.Assert(cells["E4"].Formula.Equals("B2"));
             
            // Insert one cell before E4 shifting E4 down to E5.
            cells["E4"].Insert(InsertShiftDirection.Down);
            Debug.Assert(cells["E5"].Formula.Equals("B2"));
             
            // Insert one cell before E5 shifting E5 right to F5.
            cells["E5"].Insert(InsertShiftDirection.Right);
            Debug.Assert(cells["F5"].Formula.Equals("B2"));
        }
    }
}

Visual Basic

Imports System
Imports SpreadsheetGear
Imports System.Diagnostics
             
             
Namespace SpreadsheetGear.InsertExample
            
    Class Program
             
        Shared Sub Main()
            ' Create a workbook.
            Dim workbook As IWorkbook = Factory.GetWorkbook()
            Dim worksheet As IWorksheet = workbook.Worksheets(0)
            Dim cells As IRange = worksheet.Cells
             
            ' Set some text in A1:B2.
            cells("A1").Formula = "A1"
            cells("A2").Formula = "A2"
            cells("B1").Formula = "B1"
            cells("B2").Formula = "B2"
             
            ' Insert two rows before row 2.
            cells("2:3").Insert()
             
            ' Insert three columns before column 'B'.
            cells("B:D").Insert()
             
            ' Verify new locations - A1 has not moved.
            Debug.Assert(cells("A1").Formula.Equals("A1"))
            ' A2 has been moved down two rows.
            Debug.Assert(cells("A4").Formula.Equals("A2"))
            ' B1 has been moved right three columns.
            Debug.Assert(cells("E1").Formula.Equals("B1"))
            ' B2 has been moved down two rows and right three columns.
            Debug.Assert(cells("E4").Formula.Equals("B2"))
             
            ' Insert one cell before E4 shifting E4 down to E5.
            cells("E4").Insert(InsertShiftDirection.Down)
            Debug.Assert(cells("E5").Formula.Equals("B2"))
             
            ' Insert one cell before E5 shifting E5 right to F5.
            cells("E5").Insert(InsertShiftDirection.Right)
            Debug.Assert(cells("F5").Formula.Equals("B2"))
        End Sub 'Main
    End Class 'Program
End Namespace 'SpreadsheetGear.InsertExample

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IRange Interface
IRange Members
Overload List
Delete Method
Delete(DeleteShiftDirection) Method
Insert(InsertShiftDirection) Method