AddRow(Int32) Method

Adds a row to the data model at the specified position.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub AddRow( _
   ByVal row As Integer _
)

'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
 
instance.AddRow(row)

public void AddRow( 
   int row
)

Parameters

row: Row index at which to add a new row

Example

This example adds two new rows to the model in the click event of a button

Private void Button1_Click(object sender, System.EventArgs e)
{
  FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
  dm.AddRow(2);        
}

Visual Basic

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel = CType(FpSpread1.ActiveSheetView.DataModel, FarPoint.Web.Spread.Model.DefaultSheetDataModel)
  dm.AddRow(2)
End Sub

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List