ExcelTableColumn Members

From Office Open XML

previous page next page

The ExcelTableColumn type exposes the following members.

Methods

	Name	Description
	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

	Name	Description
	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

ExcelTableColumn Class

OfficeOpenXml.Table Namespace

previous page start next page