Class LoadOptions

Namespace

SheetStream

Assembly

SheetStream.dll

Options for LoadFromCollection<T>(IEnumerable<T>, LoadOptions?), LoadFromDataTable(DataTable, LoadOptions?) and LoadFromDataReader(IDataReader, LoadOptions?).

public sealed class LoadOptions

Inheritance

object

LoadOptions

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

AutoFilter

Adds AutoFilter drop-downs to the header row (ignored when a table is created, which has its own).

public bool AutoFilter { get; set; }

Property Value

bool

ColumnStyles

Per-column styles keyed by column name (property name, header text or data column name).

public IDictionary<string, CellStyle> ColumnStyles { get; }

Property Value

IDictionary<string, CellStyle>

HeaderStyle

Style of the header cells, or null.

public CellStyle? HeaderStyle { get; set; }

Property Value

CellStyle

PrintHeaders

Write a header row with the column names. Default true.

public bool PrintHeaders { get; set; }

Property Value

bool

StartColumn

First column to write to (1-based). Default 1.

public int StartColumn { get; set; }

Property Value

int

TableName

Creates an Excel table with this name over the loaded range (header included). Requires PrintHeaders.

public string? TableName { get; set; }

Property Value

string

TableStyle

Table style when TableName is set. Default "TableStyleMedium2".

public string TableStyle { get; set; }

Property Value

string