Spread for ASP.NET 9.0 Product Documentation
SetValue Method (ISheetDataModel)
Example 


Row index
Column index
Object that contains data to set in cell
Sets data in a cell at the specified row and column.
Syntax
'Declaration
 
Sub SetValue( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As Object _
) 
'Usage
 
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
)

Parameters

row
Row index
column
Column index
value
Object that contains data to set in cell
Example
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
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

ISheetDataModel Interface
ISheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.