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 |
Set the Text property.
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"
|
|