Edit

Share via


Excel.DoubleCellValue interface

Represents the value of a cell containing a double.

Remarks

[ API set: ExcelApi 1.16 ]

Properties

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.

basicValue

Represents the value that would be returned by Range.values for a cell with this value.

layouts

Represents layout information for views of this double value.

numberFormat

Returns the number format string that is used to display this value. When accessed through a valuesAsJson property, this number format string is in the en-US locale. When accessed through a valuesAsJsonLocal property, this number format is in the user's display locale. Number format strings must conform to Excel guidelines. To learn more, see Review guidelines for customizing a number format.

properties

Represents additional properties of this double value.

provider

Represents information that describes the service that provided the data in this DoubleCellValue. This information can be used for branding in card view.

referencedValues

Represents the cell values which are referenced within DoubleCellValue.properties.

type

Represents the type of this cell value.

Property Details

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.

basicType?: RangeValueType.double | "Double";

Property Value

double | "Double"

Remarks

[ API set: ExcelApi 1.16 ]

basicValue

Represents the value that would be returned by Range.values for a cell with this value.

basicValue: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.16 ]

layouts

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Represents layout information for views of this double value.

layouts?: BasicViewLayouts;

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

numberFormat

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Returns the number format string that is used to display this value. When accessed through a valuesAsJson property, this number format string is in the en-US locale. When accessed through a valuesAsJsonLocal property, this number format is in the user's display locale. Number format strings must conform to Excel guidelines. To learn more, see Review guidelines for customizing a number format.

numberFormat?: string;

Property Value

string

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

properties

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Represents additional properties of this double value.

properties?: {
            [key: string]: EntityPropertyType;
        };

Property Value

{ [key: string]: Excel.EntityPropertyType; }

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

provider

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Represents information that describes the service that provided the data in this DoubleCellValue. This information can be used for branding in card view.

provider?: CellValueProviderAttributes;

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

referencedValues

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Represents the cell values which are referenced within DoubleCellValue.properties.

referencedValues?: ReferencedValue[];

Property Value

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

type

Represents the type of this cell value.

type: CellValueType.double | ReferenceValueType.double | "Double";

Property Value

double | double | "Double"

Remarks

[ API set: ExcelApi 1.16 ]