Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / IRangeSupport Interface / AddRows Method
Row index of row after which to add rows
Number of rows to add
Example


In This Topic
    AddRows Method (IRangeSupport)
    In This Topic
    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
    See Also

    Reference

    IRangeSupport Interface
    IRangeSupport Members

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page