WorksheetTable Class

Represents a region of cells formatted as a table.
Public Class WorksheetTable 
   Inherits NamedReferenceBase
public class WorksheetTable : NamedReferenceBase 

Tables assist in managing and analyzing a range of related data. This management can be done separately from the rest of the data in the worksheet.

A table can have one or more columns sorted and filtered. There are various sorting and filtering criteria that can be applied to the columns. The types pertaining to filtering can be found in the Infragistics.Documents.Excel.Filtering namespace and a filter can be applied to a column by setting the WorksheetTableColumn.Filter property. The types pertaining to sorting can be found in the Infragistics.Documents.Excel.Sorting namespace and a column can be sorted by setting the WorksheetTableColumn.SortCondition or by populating the Infragistics.Documents.Excel.Sorting.SortSettings<T>.SortConditions collection on the SortSettings.

A table can contain calculated columns which dynamically determine their value based on a formula. A WorksheetTableColumn can be made a calculated column by setting the WorksheetTableColumn.ColumnFormula.

A table can also contain a totals row which display total information about the table. This can be shown by setting IsTotalsRowVisible to True. When the totals row is displayed, each column can display text or a calculated value in the totals row, by setting either the WorksheetTableColumn.TotalLabel or WorksheetTableColumn.TotalFormula, respectively.


Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also