Spread for ASP.NET 11 Product Documentation
Handling Data Using Cell Properties
Spread for ASP.NET 11 Product Documentation > Developer's Guide > Managing Data in the Component > Placing and Retrieving Data > 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 Class Property
As a string with formatting (for example "$1,234.56") Text
As a string without formatting (for example "1234.45") Value

Using Code

Set the Text property.

Example

This example code sets the Text property for the cell.

C#
Copy Code
FpSpread1.Sheets[0].Cells[0,0].Text = "test"; 
VB
Copy Code
FpSpread1.Sheets(0).Cells(0,0).Text = "test" 
See Also