Infragistics(R) NetAdvantage(R) WPF
SetCellValue Method
See Also  E-mail your feedback on this topic.
Infragistics.Documents.Excel Namespace > WorksheetRow Class : SetCellValue Method

columnIndex
The 0-based index of the cell within the WorksheetRow.
value
The value to assign to the cell.
Sets the value of a cell at the specified column index.

Syntax

Visual Basic (Declaration) 
Public Sub SetCellValue( _
   ByVal columnIndex As Integer, _
   ByVal value As Object _
)
C# 
public void SetCellValue( 
   int columnIndex,
   object value
)

Parameters

columnIndex
The 0-based index of the cell within the WorksheetRow.
value
The value to assign to the cell.

Exceptions

ExceptionDescription
System.ArgumentOutOfRangeException is less than zero or greater than or equal to the number of columns in the worksheet.
System.NotSupportedException The assigned value's type is not supported and can't be exported to Excel.
System.InvalidOperationException The value assigned is a . Instead, should be called on the Formula, passing in the cell.
System.InvalidOperationException The value assigned is a . Instead, the should be set to a region containing the cell.
System.InvalidOperationException The value assigned is a FormattedString which is the value another cell or merged cell region.
System.InvalidOperationException The value is assigned and this cell is part of an or WorksheetDataTable.

Remarks

If this cell belongs to a merged cell region and it is the top-left cell of the region, getting and setting the value will get and set the value of the associated merged cell region. Getting the value of other cells in a merged cell region will always return null. Setting the value of other cells in a merged cell region will have no effect.

If a formula has been applied to the cell or a data table is associated with the cell, getting the Value will return the calculated value of the cell.

The types supported for the value are:

  • System.Byte
  • System.SByte
  • System.Int16
  • System.Int64
  • System.UInt16
  • System.UInt64
  • System.UInt32
  • System.Int32
  • System.Single
  • System.Double
  • System.Boolean
  • System.Char
  • System.Enum
  • System.Decimal
  • System.DateTime
  • System.String
  • System.Text.StringBuilder
  • System.DBNull
  • ErrorValue
  • FormattedString

See Also