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