Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Managing Data on a Sheet / Placing and Retrieving Data / Handling Data Using Cell Properties
In This Topic
    Handling Data Using Cell Properties
    In This Topic

    The following table summarizes the ways you can get or set data in cells using the properties of the cell.

    Data Description Cell Property
    As a string with formatting (for example "$1,234.56") Text
    As a string without formatting (for example "1234.45") Value

    There is no limitation on the data types of values that can be stored in cells. Cell values are assigned and retrieved using the generic Object data type. Primitive data types (for example, bool, int, double, etc.) are assigned and retrieved using boxed primitives.

    The C# and Visual Basic .NET languages automatically box primitives (that is, convert primitive to object) for you as illustrated in this code.

    Using Code

    Use the Value property or SetValue method to add data to a cell.

    Example

    This example adds data to cells.

    C#
    Copy Code
    fpSpread1.Sheets[0].Cells[0, 3].Value = 123;
    fpSpread1.Sheets[0].SetValue(0, 6, "abc");
    VB
    Copy Code
    fpSpread1.Sheets(0).Cells(0, 3).Value = 123
    fpSpread1.Sheets(0).SetValue(0, 6, "abc")

    Example

    You need to manually unbox primitives (that is, convert object to primitive) by using a cast:

    C#
    Copy Code
    int i = (int)spread.Sheets[0].Cells[0, 3].Value;
    string s = (string)spread.Sheets[0].GetValue(0, 6);
    VB
    Copy Code
    Dim i As Integer = CInt(spread.Sheets(0).Cells(0, 3).Value)
    Dim s As String = CStr(spread.Sheets(0).GetValue(0, 6))

    Note: Empty cells return a null value (Nothing in VB) that causes the cast to fail. If there is a possibility that a cell is empty or contains a value of unknown data type then your code should check the data type prior to performing the cast or should provide an exception handler to catch the exception thrown by the failed cast.