Name | Description | |
---|---|---|
Active | Gets a value indicating whether the active cell of worksheet is inside the range of this ITable object. | |
AutoFilter | Gets the filter of this ITable. | |
AutoGenerateColumns | Gets or sets whether to generate the columns automatically based on the data source. | |
Comment | Gets or sets the comment associated with the ITable object. | |
DataAllowAddNew | Gets or sets whether to allow the user to add a new row when the table is bound. | |
DataBodyRange | Gets an IRange object that represents the range of values, excluding the header row, in a table. | |
DataSource | Gets or sets the data source that populates the table. | |
HeaderRowRange | Gets an IRange object that represents the range of the header row for a table. | |
Name | Gets the name of ITable object. | |
Range | Gets an IRange object that represents the range to which the specified table in the above list applies. | |
ShowAutoFilter | Gets or sets a boolean value indicating whether the AutoFilter will be displayed. | |
ShowAutoFilterDropDown | Gets or sets a boolean value indicating whether the AutoFilter drop down for the table object is displayed. | |
ShowHeaders | Gets or sets a value indicating whether the header row is visible. | |
ShowTableStyleColumnStripes | Gets or sets a value indicating whether the Column Stripes table style is used for the specified table object. | |
ShowTableStyleFirstColumn | Gets or sets a value indicating whether the first column is formatted for the specified table object. | |
ShowTableStyleLastColumn | Gets or sets a value indicating whether the last column is displayed for the specified table object. | |
ShowTableStyleRowStripes | Gets or sets a value indicating whether the Row Stripes table style is used for the specified table object. | |
ShowTotals | Gets or sets a value indicating whether the total row is visible. | |
Slicers | Gets a list of the table slicers associated with an ITable. | |
Sort | Gets the sort object. | |
TableColumns | Gets a ITableColumns collection that represents all the columns in a ITable object. | |
TableRows | Gets a ITableRows collection that represents all the rows in a ITable object. | |
TableStyle | Gets the TableStyle indicates which style will be applied to this ITable. | |
TableStyleName | Gets the string value indicates which style will be applied to this ITable. | |
TotalsRowRange | Gets an IRange object representing the Total row, if any, from a specified table object. | |
Worksheet | Gets the worksheet object for the specified table. |