The following tables list the members exposed by WorksheetTable.
Name | Description | |
---|---|---|
![]() | AreaFormats | Gets the collection of formats used for each area of the WorksheetTable. |
![]() | Columns | Gets the collection of columns in the table. |
![]() | Comment | Gets or sets the comment associated with the named reference or table. (Inherited from Infragistics.Documents.Excel.NamedReferenceBase) |
![]() | DataAreaRegion | Gets the WorksheetRegion which represents the region of cells in the data area of the table. |
![]() | DisplayBandedColumns | Gets or sets the value which indicates whether the alternate column format should be applied to the appropriate columns of the WorksheetTable. |
![]() | DisplayBandedRows | Gets or sets the value which indicates whether the alternate row format should be applied to the appropriate rows of the WorksheetTable. |
![]() | DisplayFirstColumnFormatting | Gets or sets the value which indicates whether the first column format should be applied to the appropriate column of the WorksheetTable. |
![]() | DisplayLastColumnFormatting | Gets or sets the value which indicates whether the last column format should be applied to the appropriate column of the WorksheetTable. |
![]() | HeaderRowRegion | Gets the WorksheetRegion which represents the region of cells in the header row of the table. |
![]() | IsFilterUIVisible | Gets or sets the value indicating whether to allow filtering and show filter buttons in the table headers. |
![]() | IsHeaderRowVisible | Gets or sets the value which indicates whether the row containing column headers should be displayed. |
![]() | IsTotalsRowVisible | Gets or sets the value which indicates whether the row containing column totals should be displayed. |
![]() | Name | Gets or sets the name of the reference. (Inherited from Infragistics.Documents.Excel.NamedReferenceBase) |
![]() | Scope | Gets the scope of the named reference. (Inherited from Infragistics.Documents.Excel.NamedReferenceBase) |
![]() | SortSettings | Gets the settings which determine how the data within the table should be sorted. |
![]() | Style | Gets or sets the style to use on the WorksheetTable. |
![]() | TotalsRowRegion | Gets the WorksheetRegion which represents the region of cells in the totals row of the table. |
![]() | WholeTableRegion | Gets the WorksheetRegion which represents the region of cells in the whole table, including the header and totals rows, if visible. |
![]() | Worksheet | Gets the Worksheet to which the table belongs. |
Name | Description | |
---|---|---|
![]() | ClearFilters | Clears all filters from the columns in the table. |
![]() | ClearSortConditions | Clears all sort conditions from the columns in the table. |
![]() | DeleteColumns | Deletes one or more columns from the table |
![]() | DeleteDataRows | Deletes one or more data rows from the table |
![]() | InsertColumns | Inserts one or more columns into the table |
![]() | InsertDataRows | Inserts one or more data rows into the table |
![]() | ReapplyFilters | Re-filters all data cells in the table based on the filters from the columns in the table. |
![]() | ReapplySortConditions | Re-sorts all data cells in the table based on the sort conditions from the columns in the table. |
![]() | Resize | Overloaded. Resizes the table to a new range of data on the worksheet. |
![]() | ToString | Gets the string representation of the table. |