Enum
ExcelDateTimeOffsetWriteMode
OfficeIMO.Excel
Selects how DateTimeOffset values are written to worksheet cells.
Inheritance
- Enum
- ExcelDateTimeOffsetWriteMode
Usage
Explore 4 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 4
Inherited Methods
ToString 4 overloads
public string ToString(IFormatProvider? provider) #Inherited from Enum
Obsolete("The provider argument is not used. Use ToString() instead.")Parameters
- provider IFormatProvider?
Returns
stringpublic string ToString(string? format, IFormatProvider? provider) #Inherited from Enum
Obsolete("The provider argument is not used. Use ToString(String) instead.")Parameters
- format string?
- provider IFormatProvider?
Returns
stringValues
public const ExcelDateTimeOffsetWriteMode Text #Writes ISO 8601 round-trip text, such as 2026-03-14T09:26:53.5897932+05:45, which keeps the offset and every fractional digit. Excel has no date type with an offset. This is the default.
Value:
0public const ExcelDateTimeOffsetWriteMode Serial #Writes an Excel date serial with a date number format. The offset is lost when the value is converted to a DateTime; values Excel cannot hold as a serial, such as dates before 1900, are still written as text.
Value:
1