Edit

Share via

Excel.Interfaces.DatetimeFormatInfoData interface

  • Reference
Package:
excel

An interface describing the data returned by calling datetimeFormatInfo.toJSON().

Properties

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

dateSeparator

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

dateSeparator?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]

longDatePattern

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

longDatePattern?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]

longTimePattern

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

longTimePattern?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]

shortDatePattern

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

shortDatePattern?: string;

Property Value

string

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?: string;

Property Value

string

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

timeSeparator

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

timeSeparator?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]