Represents a worksheet table built from data returned from a PowerPivot model.
public interface class TableObject
[System.Runtime.InteropServices.Guid("000244CE-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface TableObject
Public Interface TableObject
|AdjustColumnWidth AdjustColumnWidth AdjustColumnWidth||
Specifies if the column widths are automatically adjusted for the best fit each time you refresh the specified query table. The default value is True. Boolean (bool in C#) Read/Write
|Application Application Application||
Returns an Application object that represents the Excel application. Read-only.
|Creator Creator Creator||
Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer (int in C#).
|Destination Destination Destination||
Returns the cell in the upper-left corner of the query table destination range (the range where the resulting query table will be placed). The destination range must be on the worksheet that contains the TableObject object. Range. Read-only
|EnableEditing EnableEditing EnableEditing||
True if the user can edit the specified query table. False if the user can only refresh the query table. Boolean (bool in C#) Read/Write
|EnableRefresh EnableRefresh EnableRefresh||
Specifies if the query table can be refreshed by the user. Boolean (bool in C#) Read/Write
|FetchedRowOverflow FetchedRowOverflow FetchedRowOverflow||
Specifies if the number of rows returned by the last use of the Refresh method is greater than the number of rows available on the worksheet. Boolean (bool in C#) Read-only
|ListObject ListObject ListObject|
|Parent Parent Parent||
Returns an Object that represents the parent object of the specified TableObject object. Read-only.
|PreserveColumnInfo PreserveColumnInfo PreserveColumnInfo||
Specifies if column sorting, filtering, and layout information is preserved whenever a query table is refreshed. The default value is False. Boolean (bool in C#) Read/Write
|PreserveFormatting PreserveFormatting PreserveFormatting||
True if any formatting common to the first five rows of data are applied to new rows of data in the query table. Unused cells aren’t formatted. The property is False if the last AutoFormat applied to the query table is applied to new rows of data. The default value is True. Boolean (bool in C#) Read/Write
|RefreshStyle RefreshStyle RefreshStyle||
Returns or sets the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a record set returned by a query. XlCellInsertionMode Read/Write
|ResultRange ResultRange ResultRange||
Returns a Range object that represents the area of the worksheet occupied by the specified query table. Read-only
|RowNumbers RowNumbers RowNumbers||
Specifies if row numbers are added as the first column of the specified query table. Boolean (bool in C#) Read/Write
|WorkbookConnection WorkbookConnection WorkbookConnection||
Returns the WorkbookConnection used by the TableObject for connecting to the model. The ModelConnection property on the WorkbookConnection object can then be used to get to and edit DAX etc. Read-only
|Delete() Delete() Delete()||
Deletes the TableObject object.
|Refresh() Refresh() Refresh()||
This method updates the TableObject object.