ExcelWriterOptions

Rejects settings that require materializing the source rows before writing. For data readers, disable shared strings and automatic sizing; tables require headers. The workbook writer always enforces bounded streaming, including tables with headers.

Worksheet name.

Writes column names as the first worksheet row.

Creates an Excel table over the exported range.

Optional Excel table name.

Excel table style used when ExcelWriterOptions.CreateTable is enabled.

Includes table filter buttons when a table is created.

Calculates worksheet column widths from exported values.

Uses the workbook's CellValue date and time number formats.

Writes explicit row and cell references. Disable for a smaller contiguous worksheet package.

Requests shared-string storage. The bounded writer rejects this setting; use an editable workbook for shared-string planning. Defaults to false (inline text).

Excel date system used for temporal values.

Named complete styles, copied and compiled before reading source rows or preparing the first row. Styles cannot be registered during a row callback. Memory depends on the declared catalog and columns.

Optional declared style used as the default for each data row. Headers are excluded. Row defaults override column defaults as complete styles, without merging properties.

Declared defaults for 1-based columns within the exported schema. Column formatting applies to the entire worksheet column, including headers and cells outside the data range.