Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetDataModel Interface / SetValue Method
Row index
Column index
Object that contains data to set in cell

In This Topic
    SetValue Method (ISheetDataModel)
    In This Topic
    Sets data in a cell at the specified row and column.
    Sub SetValue( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal value As Object _
    Dim instance As ISheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As Object
    instance.SetValue(row, column, value)
    void SetValue( 
       int row,
       int column,
       object value


    Row index
    Column index
    Object that contains data to set in cell
    This example returns the previously set value for the specified cell in the model.
    private void ChangeDataModel(FarPoint.Web.Spread.FpSpread ss, FarPoint.Web.Spread.Model.ISheetDataModel isd)
        isd.SetValue(0, 0, "Primary");
        ss.ActiveSheetView.DataModel = (FarPoint.Web.Spread.Model.ISheetDataModel)isd;
        object o;
        o = isd.GetValue(0, 0);
        Response.Write("The value for the cell is " + o.ToString());
    private void PageLoad(object sender, System.EventArgs e)
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel);    
    Private Sub ChangeDataModel(ByVal ss As FarPoint.Web.Spread.FpSpread, ByVal isd As FarPoint.Web.Spread.Model.ISheetDataModel)
        isd.SetValue(0, 0, "Primary")
        ss.ActiveSheetView.DataModel = isd
        Dim o As Object
        o = isd.GetValue(0, 0)
        Response.Write("The value for the cell is " & o.ToString())
    End Sub
    Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel)
    End Sub
    See Also