Skip to main content

IXlTable Members

Represents a table in a worksheet.

Properties

Name Description
Columns Provides access to the read-only collection of table columns.
Comment Gets or sets a string that provides additional information about the table.
DataFormatting Gets or sets format characteristics for the data area of the table.
HasAutoFilter Gets or sets a value indicating whether the filtering functionality is enabled for the table.
HasHeaderRow Gets a value indicating whether the header row is displayed for the table.
HasTotalRow Gets a value indicating whether the total row is displayed at the end of the table.
Name Gets or sets the table name.
Range Gets the range of cells occupied by the table.
Style Provides access to the table style options.
TableBorderFormatting Gets or sets border settings for a table.
TotalRowFormatting Gets or sets format characteristics for the total row of the table.

Methods

Name Description
GetReference(XlTablePart, String, String) Returns a reference to the specified part of the table bounded by the specified columns.
GetReference(XlTablePart, String) Returns a reference to the specified part of the table column.
GetReference(XlTablePart) Returns a reference to the specified part of the table.
GetRowReference(String, String) Returns a reference to the portion of the current row bounded by the specified columns.
GetRowReference(String) Gets a reference to the cell at the intersection of the current row and the specified table column.
See Also