Excel.Interfaces.DatetimeFormatInfoLoadOptions interface
Defines the culturally appropriate format of displaying numbers. This is based on current system culture settings.
Remarks
Properties
| $all | Specifying |
| date |
Gets the string used as the date separator. This is based on current system settings. |
| long |
Gets the format string for a long date value. This is based on current system settings. |
| long |
Gets the format string for a long time value. This is based on current system settings. |
| short |
Gets the format string for a short date value. This is based on current system settings. |
| time |
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
longDatePattern
Gets the format string for a long date value. This is based on current system settings.
longDatePattern?: boolean;Property Value
boolean
Remarks
longTimePattern
Gets the format string for a long time value. This is based on current system settings.
longTimePattern?: boolean;Property Value
boolean
Remarks
shortDatePattern
Gets the format string for a short date value. This is based on current system settings.
shortDatePattern?: boolean;Property Value
boolean
Remarks
timeSeparator
Gets the string used as the time separator. This is based on current system settings.
timeSeparator?: boolean;Property Value
boolean