SetValue(Int32,Int32,Object) Method

Sets the value for the specified cell in the specified sheet area.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetValue( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal value As System.Object _
)

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim value As System.Object
 
instance.SetValue(row, column, value)

public void SetValue( 
   System.int row,
   System.int column,
   System.object value
)

Parameters

row: The row index.
column: The column index.
value: The value to set for the specified cell.

Example

This example uses the SetValue method.

for (int rowIndex = 0; rowIndex < this.gcSpreadSheet1.ActiveSheet.RowCount; rowIndex++)
            {
                for (int colIndex = 0; colIndex < this.gcSpreadSheet1.ActiveSheet.ColumnCount; colIndex++)
                {
                    this.gcSpreadSheet1.Sheets[0].SetValue(rowIndex, colIndex, rowIndex * 10 + colIndex);
                }
            }

VB.NET

For rowIndex As Integer = 0 To Me.gcSpreadSheet1.ActiveSheet.RowCount - 1
            For colIndex As Integer = 0 To Me.GcSpreadSheet1.ActiveSheet.ColumnCount - 1
                Me.GcSpreadSheet1.Sheets(0).SetValue(rowIndex, colIndex, rowIndex * 10 + colIndex)
            Next
        Next

Requirements

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

Reference

Worksheet Class
Worksheet Members
Overload List