ListObject Members

  • [アーティクル]

Include Protected Members
Include Inherited Members

Represents a list object on a worksheet.

The ListObject type exposes the following members.

Properties

  Name Description
Public property _Default Reserved for internal use.
Public property Active Returns a Boolean value indicating whether a ListObject object in a worksheet is active — that is, whether the active cell is inside the range of the ListObject object.
Public property AlternativeText Gets or sets the descriptive (alternative) text string for the specified table.
Public property Application Returns an Application object that represents the Microsoft Excel application.
Public property AutoFilter Filters a list using the AutoFilter. Read-only.
Public property Comment Returns or sets the comment associated with the list object. Read/write String.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created.
Public property DataBodyRange Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row.
Public property DisplayName Returns or sets the display name for the specified ListObject object. Read/write String.
Public property DisplayRightToLeft Determines if the specified window, worksheet, or ListObject object is displayed from right to left instead of from left to right.
Public property HeaderRowRange Returns a Range object that represents the range of the header row for a list.
Public property InsertRowRange Returns a Range object representing the Insert row, if any, of a specified ListObject object.
Public property ListColumns Returns a ListColumns collection that represents all the columns in a ListObject object.
Public property ListRows Returns a ListRows object that represents all the rows of data in the ListObject object.
Public property Name Returns or sets the name of the ListObject object.
Public property Parent Returns the parent object for the specified object.
Public property QueryTable Returns the QueryTable object that provides a link for the ListObject object to the list server.
Public property Range Returns a Range object that represents the range to which the specified list object applies.
Public property SharePointURL Returns a String representing the URL of the SharePoint list for a given ListObject object.
Public property ShowAutoFilter Returns a Boolean value indicating whether the AutoFilter will be displayed.
Public property ShowHeaders Returns or sets if the header information should be displayed for the specified ListObject object. Read/write Boolean.
Public property ShowTableStyleColumnStripes Returns or sets if the Column Stripes table style is used for the specified ListObject object. Read/write Boolean.
Public property ShowTableStyleFirstColumn Returns or sets if the first column is formatted for the specified ListObject object. Read/write Boolean.
Public property ShowTableStyleLastColumn Returns or sets if the last column is displayed for the specified ListObject object. Read/write Boolean.
Public property ShowTableStyleRowStripes Returns or sets if the Row Stripes table style is used for the specified ListObject object. Read/write Boolean.
Public property ShowTotals Returns or sets a Boolean value to indicate whether the Total row is visible.
Public property Sort Gets or sets the sort column or columns, and sort order for the ListObject collection.
Public property SourceType Returns one of the XlListObjectSourceType constants indicating the current source of the list.
Public property Summary Gets or sets the description associated with the alternative text string for the specified table.
Public property TableStyle Gets or sets the table style for the specified ListObject object. Read/write Object.
Public property TotalsRowRange Returns a Range object representing the Total row, if any, from a specified ListObject object.
Public property XmlMap Returns an XmlMap object that represents the schema map used for the specified list.

Top

Methods

  Name Description
Public method Delete Deletes the ListObject object and clears the cell data from the worksheet.
Public method ExportToVisio Exports a ListObject object to Visio.
Public method Publish Publishes the ListObject object to a server that is running Microsoft Windows SharePoint Services.
Public method Refresh Returns the current data and schema for the list from the server that is running Microsoft Windows SharePoint Services.
Public method Resize The Resize method allows a ListObject object to be resized over a new range.
Public method Unlink Removes the link to a Microsoft Windows SharePoint Services site from a list.
Public method Unlist Removes the list functionality from a ListObject object.
Public method UpdateChanges Updates the list on a Microsoft Windows SharePoint Services site with the changes made to the list in the worksheet.

Top

See Also

Reference

ListObject Interface

Microsoft.Office.Interop.Excel Namespace