Class XlsbWriterOptions

Namespace

ExcelReader.Core.Writer.Xlsb

Assembly

ExcelReader.Core.dll

Configures how an XLSB package is written.

public sealed record XlsbWriterOptions : IEquatable<XlsbWriterOptions>

Inheritance

object

XlsbWriterOptions

Implements

IEquatable<XlsbWriterOptions>

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 XlsbWriterOptions Default { get; }

Property Value

XlsbWriterOptions

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

Mirrors PrefetchDecompression's tradeoff on the read side: worth it for single-file batch writing, not for a concurrent server workload already saturating the CPU.

UseSharedStrings

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

public bool UseSharedStrings { get; init; }

Property Value

bool