Class ExcelTableColumn

A table column

Inheritance
System.Object
XmlHelper
ExcelTableColumn
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Table
Assembly: EPPlus.dll
Syntax
public class ExcelTableColumn : XmlHelper

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);

Declaration
public string CalculatedColumnFormula { get; set; }
Property Value
Type Description
System.String

DataCellStyleName

The named style for datacells in the column

Declaration
public string DataCellStyleName { get; set; }
Property Value
Type Description
System.String

Id

The column id

Declaration
public int Id { get; set; }
Property Value
Type Description
System.Int32

Name

The name of the column

Declaration
public string Name { get; set; }
Property Value
Type Description
System.String

Position

The position of the column

Declaration
public int Position { get; }
Property Value
Type Description
System.Int32

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);

Declaration
public string TotalsRowFormula { get; set; }
Property Value
Type Description
System.String

TotalsRowFunction

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

Declaration
public RowFunctions TotalsRowFunction { get; set; }
Property Value
Type Description
RowFunctions

TotalsRowLabel

A string text in the total row

Declaration
public string TotalsRowLabel { get; set; }
Property Value
Type Description
System.String