Class ExcelTable

Namespace

SheetStream

Assembly

SheetStream.dll

An Excel table (ListObject): a named, styled range with filter buttons and banded rows that formulas can address by name (Sales[Revenue]). Create with AddTable(string, string, IReadOnlyList<string>?).

public sealed class ExcelTable

Inheritance

object

ExcelTable

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

Excel requires each table column name to equal the text of its header cell. SheetStream captures that text while the header row is written, so add the table before writing its header row, or pass the column names explicitly.

Properties

Name

Table name used in structured references, e.g. Sales.

public string Name { get; }

Property Value

string

ShowColumnStripes

Alternate column shading.

public bool ShowColumnStripes { get; set; }

Property Value

bool

ShowFilterButtons

Show the filter drop-downs in the header. Default true.

public bool ShowFilterButtons { get; set; }

Property Value

bool

ShowFirstColumn

Emphasise the first column.

public bool ShowFirstColumn { get; set; }

Property Value

bool

ShowLastColumn

Emphasise the last column.

public bool ShowLastColumn { get; set; }

Property Value

bool

ShowRowStripes

Alternate row shading. Default true.

public bool ShowRowStripes { get; set; }

Property Value

bool

StyleName

Built-in table style, e.g. "TableStyleMedium2" (default), "TableStyleLight9", "TableStyleDark1".

public string StyleName { get; set; }

Property Value

string