Spread Windows Forms 15.0
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