SetValue(Int32,Int32,Object) Method

Sets the value for the specified cell on this sheet.

Syntax

Visual Basic
C#

'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

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());

Visual Basic

Dim o As Object
FpSpread1.ActiveSheet.SetValue(0, 0, 20)
o = FpSpread1.ActiveSheet.GetValue(0, 0)
ListBox1.Items.Add(o.ToString())

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

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