Class ExcelTableColumn¶

Namespace: OfficeOpenXml.Table
Assembly: EPPlus.dll

A table column

public class ExcelTableColumn : ExcelTableDxfBase

Inheritance¶

object ← XmlHelper ← ExcelTableDxfBase ← ExcelTableColumn

Inherited Members¶

ExcelTableDxfBase.DataStyle
ExcelTableDxfBase.HeaderRowStyle
ExcelTableDxfBase.TotalsRowStyle
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

CalculatedColumnFormula¶

Sets a calculated column Formula. Be careful with this property since it is not validated.

tbl.Columns[9].CalculatedColumnFormula = string.Format("SUM(MyDataTable[[#This Row],[{0}]])",tbl.Columns[9].Name); //Reference within the current row tbl.Columns[9].CalculatedColumnFormula = string.Format("MyDataTable[[#Headers],[{0}]]",tbl.Columns[9].Name); //Reference to a column header tbl.Columns[9].CalculatedColumnFormula = string.Format("MyDataTable[[#Totals],[{0}]]",tbl.Columns[9].Name); //Reference to a column total

public string CalculatedColumnFormula { get; set; }

Property Value¶

string

DataCellStyleName¶

The named style for datacells in the column

public string DataCellStyleName { get; set; }

Property Value¶

string

Id¶

The column id

public int Id { get; set; }

Property Value¶

int

IsCalculatedFormulaArray¶

If the calculated formula is an array formula. This property will be set if the formula calculation evaluate the formula as an array formula. See Calculate(ExcelWorkbook)

public bool? IsCalculatedFormulaArray { get; set; }

Property Value¶

bool?

Exceptions¶

InvalidOperationException

If the CalculatedColumnFormula is null or empty.

Name¶

The name of the column

public string Name { get; set; }

Property Value¶

string

Position¶

The position of the column

public int Position { get; }

Property Value¶

int

Slicer¶

Returns the slicer attached to a column. If the column has multiple slicers, the first is returned.

public ExcelTableSlicer Slicer { get; }

Property Value¶

ExcelTableSlicer

Table¶

The ExcelTable containing the table column

public ExcelTable Table { get; }

Property Value¶

ExcelTable

TotalsRowFormula¶

Sets a custom Totals row Formula. Be carefull with this property since it is not validated.

tbl.Columns[9].TotalsRowFormula = string.Format("SUM([{0}])",tbl.Columns[9].Name);

public string TotalsRowFormula { get; set; }

Property Value¶

string

TotalsRowFunction¶

Build-in total row functions. To set a custom Total row formula use the TotalsRowFormula property TotalsRowFormula

public RowFunctions TotalsRowFunction { get; set; }

Property Value¶

RowFunctions

TotalsRowLabel¶

A string text in the total row

public string TotalsRowLabel { get; set; }

Property Value¶

string

Methods¶

AddSlicer()¶

Adds a slicer drawing connected to the column

public ExcelTableSlicer AddSlicer()

Returns¶

ExcelTableSlicer

The table slicer drawing object