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"
|
|