SetValue(Int32,Int32,Object) Method

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
)

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified row index is out of range; must be between 0 and the total number of rows
System.ArgumentOutOfRangeException	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())