Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / BaseSheetDataModel Class / SetValue Method
Row index
Column index
Value to set in cell
Example


In This Topic
    SetValue Method (BaseSheetDataModel)
    In This Topic
    Sets data for a cell at a specified row and column.
    Syntax
    'Declaration
     
    Public Overridable Sub SetValue( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal value As Object _
    ) 
    'Usage
     
    Dim instance As BaseSheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As Object
     
    instance.SetValue(row, column, value)
    public virtual void SetValue( 
       int row,
       int column,
       object value
    )

    Parameters

    row
    Row index
    column
    Column index
    value
    Value to set in cell
    Remarks
    use the GetValue method to return the value in a specified cell.
    Example
    This example returns the value set for the specified column and row.
    FarPoint.Web.Spread.Model.BaseSheetDataModel bdm;
    object o;
    bdm = (FarPoint.Web.Spread.Model.BaseSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
    bdm.SetValue(0, 0, "FarPoint");
    o = bdm.GetValue(0, 0);
    Response.Write("The value is " + o.ToString());
    
    Dim bdm As FarPoint.web.Spread.Model.BaseSheetDataModel
    Dim o As Object
    bdm = FpSpread1.ActiveSheetView.DataModel
    bdm.SetValue(0, 0, "FarPoint")
    o = bdm.GetValue(0, 0)
    Response.Write("The value is " & o.ToString())
    See Also