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. |