ExcelTableColumn Members

Office Open XML

The ExcelTableColumn type exposes the following members.

Methods

  NameDescription
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
ToString
Returns a String that represents the current Object.
(Inherited from Object.)

Properties

  NameDescription
CalculatedColumnFormula
Sets a calculated column Formula. Be carefull with this property since it is not validated.

Examples

tbl.Columns[9].CalculatedColumnFormula = string.Format("SUM(MyDataTable[[#This Row],[{0}]])",tbl.Columns[9].Name);
DataCellStyleName
The named style for datacells in the column
Id
The column id
Name
The name of the column
Position
The position of the column
TotalsRowFormula
Sets a custom Totals row Formula. Be carefull with this property since it is not validated.

Examples

tbl.Columns[9].TotalsRowFormula = string.Format("SUM([{0}])",tbl.Columns[9].Name);
TotalsRowFunction
Build-in total row functions. To set a custom Total row formula use the TotalsRowFormula property
TotalsRowLabel
A string text in the total row

See Also