Class XlsxWriterOptions

Namespace

ExcelReader.Core.Writer.Xlsx

Assembly

ExcelReader.Core.dll

Configures how an XLSX package is written.

public sealed record XlsxWriterOptions : IEquatable<XlsxWriterOptions>

Inheritance

object

XlsxWriterOptions

Implements

IEquatable<XlsxWriterOptions>

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

Compression

The compression level applied to each ZIP entry. Defaults to Fastest.

public CompressionLevel Compression { get; init; }

Property Value

CompressionLevel

Date1904

Whether the workbook uses the 1904 date system instead of the default 1900 system. Defaults to false.

public bool Date1904 { get; init; }

Property Value

bool

Default

The default options: 1900 date system, fastest compression, inline strings, no background deflate.

public static XlsxWriterOptions Default { get; }

Property Value

XlsxWriterOptions

PrefetchWrite

Whether each sheet's deflate runs on a background thread instead of the calling thread, overlapping compression with row serialization. Defaults to false.

public bool PrefetchWrite { get; init; }

Property Value

bool

Remarks

Intended for single-file batch writing, where overlapping deflate with row-building shortens one write's wall-clock time — not for concurrent server workloads, where the extra background thread per sheet competes with work already saturating the CPU (mirrors PrefetchDecompression's tradeoff on the read side).

UseSharedStrings

Whether string cells are deduplicated into a shared string table instead of being inlined. Defaults to false.

public bool UseSharedStrings { get; init; }

Property Value

bool