SpreadsheetGear
Insert() Method
See Also  Example Send Feedback
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

Visual Basic (Declaration) 
Overloads Sub Insert()
C# 
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 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.