Spread for ASP.NET 9.0 Product Documentation
Clear Method (IRangeSupport)
Example 


Row index of first row in selected range
Column index of first column in selected range
Number of rows in selected range
Number of columns in selected range
Removes all of the contents from the cells in the specified range of cells.
Syntax
'Declaration
 
Sub Clear( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
) 
'Usage
 
Dim instance As IRangeSupport
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.Clear(row, column, rowCount, columnCount)
void Clear( 
   int row,
   int column,
   int rowCount,
   int columnCount
)

Parameters

row
Row index of first row in selected range
column
Column index of first column in selected range
rowCount
Number of rows in selected range
columnCount
Number of columns in selected range
Example
private void Button1Click(object sender, System.EventArgs e)
{
    FarPoint.Web.Spread.Model.IRangeSupport irs;
    irs = (FarPoint.Web.Spread.Model.IRangeSupport)FpSpread1.ActiveSheetView.DataModel;
    irs.Clear(0, 0, 2, 2);
}
Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim irs As FarPoint.Web.Spread.Model.IRangeSupport
    irs = FpSpread1.ActiveSheetView.DataModel
    irs.Clear(0, 0, 2, 2)
End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

IRangeSupport Interface
IRangeSupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.