Gets or sets the value which indicates whether the alternate row format should be applied to the appropriate rows of the WorksheetTable. Syntax Remarks The row formats are defined by the WorksheetTableStyle applied to the WorksheetTable. These are stored in the WorksheetTableStyle.AreaFormats collection and keyed ...
Gets or sets the value which indicates whether the first column format should be applied to the appropriate column of the WorksheetTable. Syntax Remarks The first column format is defined by the WorksheetTableStyle applied to the WorksheetTable. It is stored in the WorksheetTableStyle.AreaFormats collection and ke...
Gets or sets the value which indicates whether the last column format should be applied to the appropriate column of the WorksheetTable. Syntax Remarks The last column format is defined by the WorksheetTableStyle applied to the WorksheetTable. It is stored in the WorksheetTableStyle.AreaFormats collection and keye...
Gets the WorksheetRegion which represents the region of cells in the header row of the table. Syntax Property Value A WorksheetRegion which represents the region of cells in the header row of the table or null if the header row is not visible.
Inserts one or more columns into the table Syntax Parameters tableColumnIndex The insertion point relative to the first column in the table.count The number of columns to insert Exceptions Exception Description System.InvalidOperationException If the operation is not allowed, e.g. if it would cause data to be shif...
Inserts one or more columns into the table Overload List
Inserts one or more data rows into the table Syntax Parameters dataRowIndex The insertion point relative to the first row in the DataAreaRegion.count The number of columns to insert Exceptions Exception Description System.InvalidOperationException If the operation is not allowed, e.g. if it would cause data to be ...
Gets or sets the value indicating whether to allow filtering and show filter buttons in the table headers. Syntax Exceptions Exception Description System.InvalidOperationException The value assigned is True and IsHeaderRowVisible is False. Remarks If IsHeaderRowVisible is False, this property must be False and set...
Gets or sets the value which indicates whether the row containing column headers should be displayed. Syntax Property Value True if the row containing column headers is visible; False if it is hidden. Remarks When the header row is visible, the cell above each column of data will contain the WorksheetTableColumn.N...
Gets or sets the value which indicates whether the row containing column totals should be displayed. Syntax Property Value True if the row containing column totals is visible; False if it is hidden. Exceptions Exception Description System.InvalidOperationException The value is set to True and the table occupies th...