CellValue Property

The value of the cell.

Syntax

[VB.NET]
Public Property CellValue As String

[C#]
public string CellValue {get; set;}

Remarks

This property holds the value of the cell. In many cases when a cell holds a simple type such as a string or number both CellValue and CellText will hold the same value.

This value may be set to update the contents of the Cell. After changing this value call Save.

This property will hold the cell's formula if present. Formulas returned by Google will always reference cells in R1C1 notation. Formulas may be set in either A1 or R1C1 notation. The formula returned by Google will XML escape the quote character. For instance:

=HYPERLINK("http://www.nsoftware.com","nsoftware")

When assigning a formula, quotes should not be XML escaped. For instance:

gsheet.CellValue = "=HYPERLINK(\"http://www.nsoftware.com\",\"nsoftware\")";

This property is not available at design time.

Default Value

""