AddRows(Int32,Int32) Method

Adds rows to the data model at the specified position.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub AddRows( _
   ByVal row As Integer, _
   ByVal count As Integer _
)

'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim count As Integer
 
instance.AddRows(row, count)

public void AddRows( 
   int row,
   int count
)

Parameters

row: Row index at which to add new rows
count: Number of rows to add

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified index of row is out of range; must be between zero and the number of columns
System.ArgumentOutOfRangeException	Specified number of rows is out of range; must be greater than zero

Example

This example adds two rows to the model.

FarPoint.Web.Spread.Model.DefaultSheetDataModel new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); 
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
dataModel.AddRows(1, 2);

Visual Basic

Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
dataModel.AddRows(1, 2)

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