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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 ]