Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / SetValue Method


In This Topic
    SetValue Method (SheetView)
    In This Topic
    Sets the value for the specified cell on this sheet.
    Sets the value for the cell of the specified row and column on this sheet.
    Overload List
    OverloadDescription
    SetValue(Int32,Int32,Object) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Boolean) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,DateTime) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Double) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Int32) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Char) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,SByte) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Byte) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Int16) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,UInt16) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,UInt32) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Int64) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,UInt64) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Single) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Decimal) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,String) Sets the value for the specified cell on this sheet.  
    SetValue(Int32,Int32,Object,Boolean) Sets the value for the specified cell on this sheet.  
    Remarks

    Besides using this method, you can get or set the value in a cell using various properties of the sheet (SheetView object) or properties of the cell (Cell object). For more information, see Handling Data Using Sheet Methods and Handling Data Using Cell Properties.

    Remember that the data may be displayed differently in a cell depending on the cell type. For more information, see Understanding Cell Type Effects on Displaying Data.

    An InvalidArgumentException is possible with this method if the value is invalid.

    See Also

    Reference

    SheetView Class
    SheetView Members
    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

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page