Spread Windows Forms 11.0 Product Documentation
RemoveRows Method (IRangeSupport)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > IRangeSupport Interface : RemoveRows Method
Row index at which to start removing rows
Number of rows to remove
Removes rows from the specified starting position.
Syntax
'Declaration
 
Sub RemoveRows( _
   ByVal row As Integer, _
   ByVal rowCount As Integer _
) 
'Usage
 
Dim instance As IRangeSupport
Dim row As Integer
Dim rowCount As Integer
 
instance.RemoveRows(row, rowCount)
void RemoveRows( 
   int row,
   int rowCount
)

Parameters

row
Row index at which to start removing rows
rowCount
Number of rows to remove
Example
This example removes the specified number of columns and rows.
FarPoint.Win.Spread.Model.IRangeSupport irs;
DialogResult dlg;
irs = (FarPoint.Win.Spread.Model.IRangeSupport)fpSpread1.ActiveSheet.Models.Data;
dlg = MessageBox.Show("Do you want to remove some columns and rows?", "RemoveColumns/Rows", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
irs.RemoveColumns(3, 496);
irs.RemoveRows(3, 496);
}
Dim irs As FarPoint.Win.Spread.Model.IRangeSupport
Dim dlg As DialogResult
irs = FpSpread1.ActiveSheet.Models.Data
dlg = MessageBox.Show("Do you want to remove some columns and rows?", "RemoveColumns/Rows", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
irs.RemoveColumns(3, 496)
irs.RemoveRows(3, 496)
End If
See Also

Reference

IRangeSupport Interface
IRangeSupport Members