Skip to main content

IXlTableColumn Members

Represents a single column in a table.

Properties

Name Description
DataFormatting Gets or sets format characteristics for the data area of the table column.
FilterCriteria Gets or sets the filter criteria that should be applied to the table column.
HiddenButton Gets or set a value indicating whether the AutoFilter button for the specified table column should be hidden.
Name Gets the unique name of the table column.
TotalRowFormatting Gets or sets format characteristics for the total row cell of the table column.
TotalRowFunction Gets or sets the function to calculate the total of the table column.
TotalRowLabel Gets or sets the text displayed in the total cell of the table column.

Methods

Name Description
SetFormula(IXlFormulaParameter) Specifies the formula to apply to all cells in the table column.
SetFormula(XlExpression) Specifies the formula to apply to all cells in the table column.
SetFormula(String) Specifies the formula to apply to all cells in the table column.
See Also