Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / Clear(Int32,Int32,Int32,Int32,ManipulationOptions) Method
An integer value indicates the top row index of cell range.
An integer value indicates the left column index of cell range.
An integer value indicates the total number of rows.
An integer value indicates the total number of columns.


In This Topic
Clear(Int32,Int32,Int32,Int32,ManipulationOptions) Method
In This Topic
Removes all the data and formulas from the specified range of cells.
Syntax
'Declaration
 
Public Function Clear( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal options As ManipulationOptions _
) As ActionResult(Of Object)
 
'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim options As ManipulationOptions
Dim value As ActionResult(Of Object)
 
value = instance.Clear(row, column, rowCount, columnCount, options)

Parameters

row
An integer value indicates the top row index of cell range.
column
An integer value indicates the left column index of cell range.
rowCount
An integer value indicates the total number of rows.
columnCount
An integer value indicates the total number of columns.
options

Return Value

true if the data is clear, false otherwise.
See Also