ExcelTableColumn Properties

previous page next page

The ExcelTableColumn type exposes the following members.

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