ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLCell Class / SetValue Method
New cell value.
New cell style.

In This Topic
    SetValue Method
    In This Topic
    Sets the Value and Style properties of a cell.
    Syntax
    'Declaration
 
Public Sub SetValue( _
   ByVal value As System.Object, _
   ByVal style As XLStyle _
) 
    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;
    See Also

    Reference

    XLCell Class
    XLCell Members