Re-filters all data cells in the table based on the filters from the columns in the table. Syntax Remarks Filters are not constantly evaluated as data within the table changes. Filters are applied to the table only when they are added or removed on a column in the table or when the ReapplyFilters method is called....
Re-sorts all data cells in the table based on the sort conditions from the columns in the table. Syntax
Resizes the table to a new range of data on the worksheet. Syntax Parameters headerAndDataRegionAddress The address of the new region of headers (if currently visible) and data for the table, which must contain at least one data row, and overlap and have the same top as the current table region. Exceptions Excepti...
Resizes the table to a new range of data on the worksheet. Syntax Parameters headerAndDataRegionAddress The address of the new region of headers (if currently visible) and data for the table, which must contain at least one data row, and overlap and have the same top as the current table region.cellReferenceMode T...
Resizes the table to a new range of data on the worksheet. Syntax Parameters headerAndDataRegion The new region of headers (if currently visible) and data for the table, which must contain at least one data row, and overlap and have the same top as the current table region. Exceptions Exception Description System....
Resizes the table to a new range of data on the worksheet. Overload List
Gets the settings which determine how the data within the table should be sorted. Syntax Remarks Note: Sort conditions are not constantly evaluated as data within the table changes. Sort conditions are applied to the table only when they are are added or removed on a column in the table or when the ReapplySortCond...
Gets or sets the style to use on the WorksheetTable. Syntax Property Value The WorksheetTableStyle instance which defines the various default table area formats. Exceptions Exception Description System.ArgumentException The value specified is not in the CustomTableStyles or StandardTableStyles collections. Remarks...
Gets the string representation of the table. Syntax Return Value The string representation of the table.
Gets the string representation of the table. Overload List