Table

public sealed class Table

Namespace SharpCell · package SharpCell

An Excel table: a named range with column names, an optional header row and an optional totals row. Formulas refer to it by name, as in Sales[Units]. A table does not change after it is created.

Properties

Columns

public IReadOnlyList<string> Columns { get; }

The column names from left to right.

HasHeaderRow

public bool HasHeaderRow { get; }

Whether the first row holds the column names.

HasTotalsRow

public bool HasTotalsRow { get; }

Whether the last row holds totals.

Name

public string Name { get; }

The name formulas use, such as Sales in Sales[Units].

Range

public string Range { get; }

The whole table as an A1 range, header and totals rows included, such as A1:D10.

Worksheet

public Worksheet Worksheet { get; }

The sheet the table is on.

Methods

ToString()

public override string ToString()

The table name.