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