# GoogleSheetsCellValue

Normalized value payload used in compiled Google Sheets requests.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[GoogleSheetsRequest.cs:464](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L464)

**Modifiers**

sealed

Normalized value payload used in compiled Google Sheets requests.

## Inheritance

- object
- GoogleSheetsCellValue

## Usage

Explore 7 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

### Returned or exposed by 7

- Property [GoogleSheetsCellData.Value](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetscelldata/#property-value)
- Method [GoogleSheetsCellValue.Blank](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetscellvalue/#method-blank)
- Method [GoogleSheetsCellValue.Boolean](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetscellvalue/#method-boolean-boolean)
- Method [GoogleSheetsCellValue.DateTime](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetscellvalue/#method-datetime-datetime)
- Method [GoogleSheetsCellValue.Formula](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetscellvalue/#method-formula-string)
- Method [GoogleSheetsCellValue.Number](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetscellvalue/#method-number-double)
- Method [GoogleSheetsCellValue.String](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetscellvalue/#method-string-string)

Filter members 

Show inherited

## Methods

`public static GoogleSheetsCellValue Blank()` [#](#method-blank)

[GoogleSheetsRequest.cs:464](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L464)

Creates a blank cell value.

Returns

`GoogleSheetsCellValue`

`public static GoogleSheetsCellValue Boolean(bool value)` [#](#method-boolean-boolean)

[GoogleSheetsRequest.cs:470](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L470)

Creates a Boolean cell value.

Parameters

**value bool required**

Returns

`GoogleSheetsCellValue`

`public static GoogleSheetsCellValue DateTime(DateTime value)` [#](#method-datetime-datetime)

[GoogleSheetsRequest.cs:472](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L472)

Creates a date/time cell value.

Parameters

**value System.DateTime required**

Returns

`GoogleSheetsCellValue`

`public static GoogleSheetsCellValue Formula(string formula)` [#](#method-formula-string)

[GoogleSheetsRequest.cs:474](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L474)

Creates a formula cell value, treating null as empty.

Parameters

**formula string required**

Returns

`GoogleSheetsCellValue`

`public static GoogleSheetsCellValue Number(double value)` [#](#method-number-double)

[GoogleSheetsRequest.cs:468](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L468)

Creates a numeric cell value.

Parameters

**value double required**

Returns

`GoogleSheetsCellValue`

`public static GoogleSheetsCellValue String(string? value)` [#](#method-string-string)

[GoogleSheetsRequest.cs:466](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L466)

Creates text, treating null as empty.

Parameters

**value string? required**

Returns

`GoogleSheetsCellValue`

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public GoogleSheetsCellValueKind Kind { get; }` [#](#property-kind)

[GoogleSheetsRequest.cs:459](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L459)

Gets the normalized value category.

`public object? Value { get; }` [#](#property-value)

[GoogleSheetsRequest.cs:461](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L461)

Gets the boxed value, or null for a blank cell.

<!-- PowerForge markdown artifact sha256:8B2DC443EB0D163AD3B7BFF9CDDB9201AE52CA78E67337DE079F988651809A49 -->
