Version

WorksheetTableColumn Class Members

The following tables list the members exposed by WorksheetTableColumn.

Public Properties
 NameDescription
Public PropertyAreaFormatsGets the collection of formats used for each area of the column.  
Public PropertyColumnFormulaGets the formula associated with the data area of the column.  
Public PropertyDataAreaRegionGets the WorksheetRegion which represents the region of cells in the data area of the column.  
Public PropertyFilterGets the filter applied to the column.  
Public PropertyHeaderCellGets the WorksheetCell which represents the header cell for the column.  
Public PropertyIndexGets the 0-based index of the column in the owning WorksheetTable.Columns collection.  
Public PropertyNameGets or sets the name of the column.  
Public PropertySortConditionGets or sets the sort condition used to sort the column in the table.  
Public PropertyTableGets the WorksheetTable to which the column belongs.  
Public PropertyTotalCellGets the WorksheetCell which represents the total cell for the column.  
Public PropertyTotalFormulaGets or sets the formula to use in the total cell of the column.  
Public PropertyTotalLabelGets or sets the text label to use in the total cell of the column.  
Public PropertyWholeColumnRegionGets the WorksheetRegion which represents the region of cells in the whole column, including the header and total cells, if visible.  
Public Methods
 NameDescription
Public MethodApplyAverageFilterApplies an Infragistics.Documents.Excel.Filtering.AverageFilter to the column.  
Public MethodApplyCustomFilterOverloaded. Applies a Infragistics.Documents.Excel.Filtering.CustomFilter to the column.  
Public MethodApplyDatePeriodFilterApplies an Infragistics.Documents.Excel.Filtering.DatePeriodFilter to the column.  
Public MethodApplyFillFilterApplies a Infragistics.Documents.Excel.Filtering.FillFilter to the column.  
Public MethodApplyFixedValuesFilterOverloaded. Applies a Infragistics.Documents.Excel.Filtering.FixedValuesFilter to the column.  
Public MethodApplyFontColorFilterOverloaded. Applies a Infragistics.Documents.Excel.Filtering.FontColorFilter to the column.  
Public MethodApplyIconFilterApplies a Infragistics.Documents.Excel.Filtering.IconFilter to the column.  
Public MethodApplyRelativeDateRangeFilterApplies a Infragistics.Documents.Excel.Filtering.RelativeDateRangeFilter to the column.  
Public MethodApplyTopOrBottomFilterOverloaded. Applies a Infragistics.Documents.Excel.Filtering.TopOrBottomFilter to the column which will filter in the top 10 values in the list of sorted values.  
Public MethodApplyYearToDateFilterApplies a Infragistics.Documents.Excel.Filtering.YearToDateFilter to the column.  
Public MethodClearFilterRemoves the filter from the column if one is applied.  
Public MethodSetColumnFormulaSets the formula to use in the data cells in the column.  
See Also