Spread Windows Forms 11.0 Product Documentation
SetValue(Int32,Int32,Object) Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > SetValue Method : SetValue(Int32,Int32,Object) Method
Row index
Column index
Value to set for the specified cell
Sets the value for the specified cell on this sheet.
Syntax
'Declaration
 
Public Overloads Sub SetValue( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As Object _
) 
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As Object
 
instance.SetValue(row, column, value)
public void SetValue( 
   int row,
   int column,
   object value
)

Parameters

row
Row index
column
Column index
value
Value to set for the specified cell
Exceptions
ExceptionDescription
Specified row index is out of range; must be between 0 and the total number of rows
Specified column index is out of range; must be between 0 and the total number of columns
Example
This example illustrates the use of this member by returning the value (unformatted data) for the specified cell.
object o;
fpSpread1.ActiveSheet.SetValue(0, 0, 20);
o = fpSpread1.ActiveSheet.GetValue(0, 0);
listBox1.Items.Add(o.ToString());
Dim o As Object
FpSpread1.ActiveSheet.SetValue(0, 0, 20)
o = FpSpread1.ActiveSheet.GetValue(0, 0)
ListBox1.Items.Add(o.ToString())
See Also

Reference

SheetView Class
SheetView Members
Overload List
SetArray Method
SetClip Method
SetClipValue Method
SetValue Method
Cell.Text Property
Cell.Value Property
SetText Method

User-Task Documentation

Placing and Retrieving Data
Handling Data Using Sheet Methods