Public Methods
Public Properties
Gets the collection of formats used for each area of the WorksheetTable. Syntax Remarks The available areas of the table which can have a format set are the whole table, header, data, and totals areas. Applying a format to an area will apply the format to all cells in that area. If any area formats on the tables a...
Clears all filters from the columns in the table. Syntax Remarks If any filters are present and removed when this is called, all hidden rows in the data area of the table will be unhidden.
Clears all sort conditions from the columns in the table. Syntax Remarks Note: Just as in Microsoft Excel, clearing the sort conditions will not revert the table back to its original unsorted state. The table will remain in its last sorted order.
Gets the collection of columns in the table. Syntax Remarks Each column is represented by a WorksheetTableColumn instance and contains various settings for controlling the contents, formatting, sorting, and filtering of the column.
Gets the WorksheetRegion which represents the region of cells in the data area of the table. Syntax Remarks The data area of the table can be changed by using one of the Resize overloads.
Deletes one or more columns from the table Syntax Parameters tableColumnIndex The deletion start relative to the first column in the table.count The number of columns to delete. Exceptions Exception Description System.InvalidOperationException If the operation is not allowed, e.g. if it would cause data to be shif...
Deletes one or more data rows from the table Syntax Parameters dataRowIndex The deletion start relative to the first row in the DataAreaRegion.count The number of rows to delete. Exceptions Exception Description System.InvalidOperationException If the operation is not allowed, e.g. if it would cause data to be shi...
Gets or sets the value which indicates whether the alternate column format should be applied to the appropriate columns of the WorksheetTable. Syntax Remarks The column formats are defined by the WorksheetTableStyle applied to the WorksheetTable. These are stored in the WorksheetTableStyle.AreaFormats collection a...