| Visual Basic (Declaration) | |
|---|---|
Public Overloads Sub SetValue( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal value As Object, _ ByVal validate As Boolean _ )  | |
| Visual Basic (Usage) |  Copy Code | 
|---|---|
Dim instance As SheetView Dim row As Integer Dim column As Integer Dim value As Object Dim validate As Boolean instance.SetValue(row, column, value, validate)  | |
Parameters
- row
 - Row index
 - column
 - Column index
 - value
 - Value to set for the specified cell
 - validate
 - Perform value validation
 
| 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 | 
The validate parameter specifies whether to validate the data.
            
            This example sets a value in the cell.
             
            
            | C# |  Copy Code | 
|---|---|
object o;
fpSpread1.ActiveSheet.SetValue(0, 0, 20);
o = fpSpread1.ActiveSheet.GetValue(0, 0);
listBox1.Items.Add(o.ToString()); | |
| Visual Basic |  Copy Code | 
|---|---|
Dim o As Object FpSpread1.ActiveSheet.SetValue(0, 0, 20) o = FpSpread1.ActiveSheet.GetValue(0, 0) ListBox1.Items.Add(o.ToString())  | |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8