ListObject ListObject ListObject Interface

Definition

Represents a list object on a worksheet.

public interface class ListObject
[System.Runtime.InteropServices.Guid("00024471-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ListObject
Public Interface ListObject
Attributes

Remarks

The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.

Use the ListObjects property of the Worksheet to return a ListObjects collection.

Properties

_Default _Default _Default

Reserved for internal use.

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

AlternativeText AlternativeText AlternativeText

Gets or sets the descriptive (alternative) text string for the specified table.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

AutoFilter AutoFilter AutoFilter

Filters a list using the AutoFilter. Read-only.

Comment Comment Comment

Returns or sets the comment associated with the list object. Read/write String.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

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

DisplayName DisplayName DisplayName

Returns or sets the display name for the specified ListObject object. Read/write String.

DisplayRightToLeft DisplayRightToLeft DisplayRightToLeft

Determines if the specified window, worksheet, or ListObject object is displayed from right to left instead of from left to right.

HeaderRowRange HeaderRowRange HeaderRowRange

Returns a Range object that represents the range of the header row for a list.

InsertRowRange InsertRowRange InsertRowRange

Returns a Range object representing the Insert row, if any, of a specified ListObject object.

ListColumns ListColumns ListColumns

Returns a ListColumns collection that represents all the columns in a ListObject object.

ListRows ListRows ListRows

Returns a ListRows object that represents all the rows of data in the ListObject object.

Name Name Name

Returns or sets the name of the ListObject object.

Parent Parent Parent

Returns the parent object for the specified object.

QueryTable QueryTable QueryTable

Returns the QueryTable object that provides a link for the ListObject object to the list server.

Range Range Range

Returns a Range object that represents the range to which the specified list object applies.

SharePointURL SharePointURL SharePointURL

Returns a String representing the URL of the SharePoint list for a given ListObject object.

ShowAutoFilter ShowAutoFilter ShowAutoFilter

Returns a Boolean value indicating whether the AutoFilter will be displayed.

ShowAutoFilterDropDown ShowAutoFilterDropDown ShowAutoFilterDropDown

True when the AutoFilter drop down for the ListObject object is displayed. Boolean (bool in C#) Read/Write

ShowHeaders ShowHeaders ShowHeaders

Returns or sets if the header information should be displayed for the specified ListObject object. Read/write Boolean.

ShowTableStyleColumnStripes ShowTableStyleColumnStripes ShowTableStyleColumnStripes

Returns or sets if the Column Stripes table style is used for the specified ListObject object. Read/write Boolean.

ShowTableStyleFirstColumn ShowTableStyleFirstColumn ShowTableStyleFirstColumn

Returns or sets if the first column is formatted for the specified ListObject object. Read/write Boolean.

ShowTableStyleLastColumn ShowTableStyleLastColumn ShowTableStyleLastColumn

Returns or sets if the last column is displayed for the specified ListObject object. Read/write Boolean.

ShowTableStyleRowStripes ShowTableStyleRowStripes ShowTableStyleRowStripes

Returns or sets if the Row Stripes table style is used for the specified ListObject object. Read/write Boolean.

ShowTotals ShowTotals ShowTotals

Returns or sets a Boolean value to indicate whether the Total row is visible.

Slicers Slicers Slicers

Returns a list of the table slicers associated with a ListObject. Read-only

Sort Sort Sort

Gets or sets the sort column or columns, and sort order for the ListObject collection.

SourceType SourceType SourceType

Returns one of the XlListObjectSourceType constants indicating the current source of the list.

Summary Summary Summary

Gets or sets the description associated with the alternative text string for the specified table.

TableObject TableObject TableObject

Returns a TableObject object. Read-only

TableStyle TableStyle TableStyle

Gets or sets the table style for the specified ListObject object. Read/write Object.

TotalsRowRange TotalsRowRange TotalsRowRange

Returns a Range object representing the Total row, if any, from a specified ListObject object.

XmlMap XmlMap XmlMap

Returns an XmlMap object that represents the schema map used for the specified list.

Methods

Delete() Delete() Delete()

Deletes the ListObject object and clears the cell data from the worksheet.

ExportToVisio() ExportToVisio() ExportToVisio()

Exports a ListObject object to Visio.

Publish(Object, Boolean) Publish(Object, Boolean) Publish(Object, Boolean)

Publishes the ListObject object to a server that is running Microsoft Windows SharePoint Services.

Refresh() Refresh() Refresh()

Returns the current data and schema for the list from the server that is running Microsoft Windows SharePoint Services.

Resize(Range) Resize(Range) Resize(Range)

The Resize method allows a ListObject object to be resized over a new range.

Unlink() Unlink() Unlink()

Removes the link to a Microsoft Windows SharePoint Services site from a list.

Unlist() Unlist() Unlist()

Removes the list functionality from a ListObject object.

UpdateChanges(XlListConflict) UpdateChanges(XlListConflict) UpdateChanges(XlListConflict)

Updates the list on a Microsoft Windows SharePoint Services site with the changes made to the list in the worksheet.

Applies to