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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members
Overload List