Excel.Interfaces.DatetimeFormatInfoLoadOptions interface

Package:

excel

Defines the culturally appropriate format of displaying numbers. This is based on current system culture settings.

Remarks

[ API set: ExcelApi 1.12 ]

Properties

$all	Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
dateSeparator	Gets the string used as the date separator. This is based on current system settings.
longDatePattern	Gets the format string for a long date value. This is based on current system settings.
longTimePattern	Gets the format string for a long time value. This is based on current system settings.
shortDatePattern	Gets the format string for a short date value. This is based on current system settings.
shortDateTimePattern	Gets the format string for a short date and time value. This is based on current system settings.
timeSeparator	Gets the string used as the time separator. This is based on current system settings.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

dateSeparator

Gets the string used as the date separator. This is based on current system settings.

dateSeparator?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

longDatePattern

Gets the format string for a long date value. This is based on current system settings.

longDatePattern?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

longTimePattern

Gets the format string for a long time value. This is based on current system settings.

longTimePattern?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

shortDatePattern

Gets the format string for a short date value. This is based on current system settings.

shortDatePattern?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

shortDateTimePattern

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.

Gets the format string for a short date and time value. This is based on current system settings.

shortDateTimePattern?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

timeSeparator

Gets the string used as the time separator. This is based on current system settings.

timeSeparator?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]