-
Spread Windows Forms Product Documentation
- Getting Started
-
Developer's Guide
- Understanding the Product
- Working with the Component
- Spreadsheet Objects
- Ribbon Control
- Sheets
- Rows and Columns
- Headers
-
Cells
- Working with the Active Cell
- Adding Hyperlink in a Cell
- Creating a Range of Cells
- Managing Data on a Sheet
- Displaying Cell Data
- Creating a Span of Cells
- Allowing Cells to Merge Automatically
- Adding a Note to a Cell
- Adding a Tag to a Cell
- Displaying Text Tips in a Cell
- Working with Cell Format Strings
- Working with Pattern and Gradient Fill Effects
- Inserting Cells
- Setting Rich Text in a Cell
- Adding a Comment to a Cell
- Adding Image in a Cell
- Formatting a Cell Value
- Cell Types
- Data Binding
- Customizing the Sheet Appearance
- Customizing Interaction in Cells
- Tables
- Understanding the Underlying Models
- Customizing Row or Column Interaction
- Formulas in Cells
- Sparklines
- Keyboard Interaction
- Events from User Actions
- File Operations
- Storing Excel Summary and View
- Printing
- Chart Control
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
Handling Data Using Cell Properties
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") | |
As a string without formatting (for example "1234.45") |
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.
fpSpread1.Sheets[0].Cells[0, 3].Value = 123;
fpSpread1.Sheets[0].SetValue(0, 6, "abc");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:
int i = (int)spread.Sheets[0].Cells[0, 3].Value;
string s = (string)spread.Sheets[0].GetValue(0, 6);Dim i As Integer = CInt(spread.Sheets(0).Cells(0, 3).Value)
Dim s As String = CStr(spread.Sheets(0).GetValue(0, 6))!type=note
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.