Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Enum

ExcelDateTimeOffsetWriteMode

OfficeIMO.Excel

Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
ba882f6b0d07 with working tree changes
Base
Enum
Implements
IComparable ISpanFormattable IFormattable IConvertible
Modifiers
sealed

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.

Values

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: 0
public 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