TableColumn Class

Namespace:
GemBox.Spreadsheet.Tables
Assembly:
GemBox.Spreadsheet.dll

Represents a Table column. Supported in XLSX only.

public sealed class TableColumn
Public NotInheritable Class TableColumn
Inheritance:
System.Object
TableColumn

Properties

DataRange

Gets the column data range.

public CellRange DataRange { get; }
Public ReadOnly Property DataRange As CellRange
Property Value
CellRange
Remarks

Property returns column range without header row and, if enabled, totals row.

Index

Gets the column index.

public int Index { get; }
Public ReadOnly Property Index As Integer
Property Value
System.Int32

The column index.

Name

Gets or sets the column name.

public string Name { get; set; }
Public Property Name As String
Property Value
System.String

The column name.

NameCore

Gets the column name without filling any value if it is null

public string NameCore { get; }
Public ReadOnly Property NameCore As String
Property Value
System.String

The column name

Parent

Gets the parent Table.

public Table Parent { get; }
Public ReadOnly Property Parent As Table
Property Value
Table

The parent Table.

Range

Gets the column range.

public CellRange Range { get; }
Public ReadOnly Property Range As CellRange
Property Value
CellRange
Remarks

Property returns complete column range which includes header row and, if enabled, totals row.

TotalsRowFormula

Gets or sets the totals row formula.

public string TotalsRowFormula { get; set; }
Public Property TotalsRowFormula As String
Property Value
System.String

The totals row formula.

Exceptions
System.InvalidOperationException

Parent table doesn't have totals row.

TotalsRowFunction

Gets or sets the totals row function.

public TotalsRowFunction TotalsRowFunction { get; set; }
Public Property TotalsRowFunction As TotalsRowFunction
Property Value
TotalsRowFunction

The totals row function.

Exceptions
System.InvalidOperationException

Parent table doesn't have totals row.