SpreadsheetGear The Performance Spreadsheet Component Company 
Insert() Method
See Also  Example
SpreadsheetGear Namespace > IRange Interface > Insert Method : Insert() Method
Inserts rows or columns by shifting rows down or columns right and fixing up formulas and formats.

Syntax

C# 
virtual void Insert()

Example

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

Remarks

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

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also