# ExcelDateTimeOffsetWriteMode

Selects how DateTimeOffset values are written to worksheet cells.

Enum 

`OfficeIMO.Excel`

**Namespace**

`OfficeIMO.Excel`

**Assembly**

`OfficeIMO.Excel`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[ExcelDateTimeOffsetWriteMode.cs:5](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel/ExcelDateTimeOffsetWriteMode.cs#L5)

**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.

### Returned or exposed by 4

- Field [ExcelDateTimeOffsetWriteMode.Serial](/api/excel/officeimo-excel-exceldatetimeoffsetwritemode/#field-serial)
- Field [ExcelDateTimeOffsetWriteMode.Text](/api/excel/officeimo-excel-exceldatetimeoffsetwritemode/#field-text)
- Property [ExcelDocument.DateTimeOffsetWriteMode](/api/excel/officeimo-excel-exceldocument/#property-datetimeoffsetwritemode)
- Property [ExcelWriterOptions.DateTimeOffsetWriteMode](/api/excel/officeimo-excel-excelwriteroptions/#property-datetimeoffsetwritemode)

Filter members 

Show inherited

## Inherited Methods

`public int CompareTo(object? target)` [#](#method-compareto-object)

Inherited from Enum

Parameters

**target object? required**

Returns

`int`

`public override bool Equals(object? obj)` [#](#method-equals-object)

Inherited from Enum

Parameters

**obj object? required**

Returns

`bool`

`public override int GetHashCode()` [#](#method-gethashcode)

Inherited from Enum

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public TypeCode GetTypeCode()` [#](#method-gettypecode)

Inherited from Enum

Returns

`TypeCode`

`public bool HasFlag(Enum flag)` [#](#method-hasflag-enum)

Inherited from Enum

Parameters

**flag Enum required**

Returns

`bool`

ToString 4 overloads

`public override string ToString()` [#](#method-tostring)

Inherited from Enum

Returns

`string`

`public string ToString(string? format)` [#](#method-tostring-string)

Inherited from Enum

Parameters

**format string? required**

Returns

`string`

`public string ToString(IFormatProvider? provider)` [#](#method-tostring-iformatprovider)

Inherited from Enum

`Obsolete("The provider argument is not used. Use ToString() instead.")`

Parameters

**provider IFormatProvider? required**

Returns

`string`

`public string ToString(string? format, IFormatProvider? provider)` [#](#method-tostring-string-iformatprovider)

Inherited from Enum

`Obsolete("The provider argument is not used. Use ToString(String) instead.")`

Parameters

**format string? required**

**provider IFormatProvider? required**

Returns

`string`

## Values

`public const ExcelDateTimeOffsetWriteMode Text` [#](#field-text)

[ExcelDateTimeOffsetWriteMode.cs:10](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel/ExcelDateTimeOffsetWriteMode.cs#L10)

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` [#](#field-serial)

[ExcelDateTimeOffsetWriteMode.cs:16](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel/ExcelDateTimeOffsetWriteMode.cs#L16)

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`

<!-- PowerForge markdown artifact sha256:158F6F0EBA5B6DA0A210F0E40B98E92E72F600E872FFF338BDDA5084A52A1CD6 -->
