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 carefull 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

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