Class ExcelTableColumn

Namespace

OfficeOpenXml.Table

Assembly

EPPlus.dll

A table column

public class ExcelTableColumn : ExcelTableDxfBase

Inheritance

object

XmlHelper

ExcelTableDxfBase

ExcelTableColumn

Inherited Members

ExcelTableDxfBase.HeaderRowStyle

ExcelTableDxfBase.DataStyle

ExcelTableDxfBase.TotalsRowStyle

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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