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.
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 ]

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 ]