SetValue Method

Sets the Value and Style properties of a cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SetValue( _
   ByVal value As System.Object, _
   ByVal style As XLStyle _
)

'Usage
 
Dim instance As XLCell
Dim value As System.Object
Dim style As XLStyle
 
instance.SetValue(value, style)

public void SetValue( 
   System.object value,
   XLStyle style
)

Parameters

value: New cell value.
style: New cell style.

Remarks

This method allows you to set the Value and Style properties of a cell simultaneously. This can make your code more compact and easier to maintain. For example:

// set cell value and style (short version) sheet[0,0].SetValue("Hello", styleBold); // set cell value and style (longer version) sheet[0,0].Value = "Hello"; sheet[0,0].Style = styleBold;

Reference

XLCell Class
XLCell Members