| 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