Spread Windows Forms 8.0 Product Documentation
AddRows Method (IRangeSupport)
Example 


Row index of row after which to add rows
Number of rows to add
Adds rows of cells after the specified row.
Syntax
'Declaration
 
Sub AddRows( _
   ByVal row As Integer, _
   ByVal rowCount As Integer _
) 
'Usage
 
Dim instance As IRangeSupport
Dim row As Integer
Dim rowCount As Integer
 
instance.AddRows(row, rowCount)
void AddRows( 
   int row,
   int rowCount
)

Parameters

row
Row index of row after which to add rows
rowCount
Number of rows to add
Example
This example adds columns and rows to the active sheet with the range support interface.
FarPoint.Win.Spread.Model.IRangeSupport irs;
DialogResult dlg;
irs = (FarPoint.Win.Spread.Model.IRangeSupport)fpSpread1.ActiveSheet.Models.Data;
fpSpread1.ActiveSheet.ColumnCount = 2;
fpSpread1.ActiveSheet.RowCount = 2;
dlg = MessageBox.Show("Do you want to add some columns and rows?", "AddColumns", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
irs.AddColumns(1, 3);
irs.AddRows(1, 3);
}
Dim irs As FarPoint.Win.Spread.Model.IRangeSupport
Dim dlg As DialogResult
irs = FpSpread1.ActiveSheet.Models.Data
FpSpread1.ActiveSheet.ColumnCount = 2
FpSpread1.ActiveSheet.RowCount = 2
dlg = MessageBox.Show("Do you want to add some columns and rows?", "AddColumns", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
irs.AddColumns(1, 3)
irs.AddRows(1, 3)
End If
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

IRangeSupport Interface
IRangeSupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.