Spread ASP.NET 6.0 Product Documentation
AddRows(Int32,Int32) Method
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : AddRows(Int32,Int32) Method


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

Glossary Item Box

Adds rows to the data model at the specified position.

Syntax

Visual Basic (Declaration) 
Public Sub AddRows( _
   ByVal row As Integer, _
   ByVal count As Integer _
)
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim count As Integer
 
instance.AddRows(row, count)
C# 
public void AddRows( 
   int row,
   int count
)

Parameters

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

Exceptions

ExceptionDescription
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.
C#Copy Code
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 BasicCopy Code
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
dataModel.AddRows(1, 2)

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.