ListObject Members 

Represents a list object on a worksheet.

The following tables list the members exposed by the ListObject type.

Public Properties

	Name	Description
	_Default
	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.
	Application	Returns an Application object that represents the Microsoft Excel application.
	Creator	Returns a 32-bit integer that indicates the application in which this object was created.
	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.
	DisplayRightToLeft	Determines if the specified window, worksheet, or ListObject object is displayed from right to left instead of from left to right.
	HeaderRowRange	Returns a Range object that represents the range of the header row for a list.
	InsertRowRange	Returns a Range object representing the Insert row, if any, of a specified ListObject object.
	ListColumns	Returns a ListColumns collection that represents all the columns in a ListObject object.
	ListRows	Returns a ListRows object that represents all the rows of data in the ListObject object.
	Name	Returns or sets the name of the ListObject object.
	Parent	Returns the parent object for the specified object.
	QueryTable	Returns the QueryTable object that provides a link for the ListObject object to the list server.
	Range	Returns a Range object that represents the range to which the specified list object applies.
	SharePointURL	Returns a String representing the URL of the SharePoint list for a given ListObject object.
	ShowAutoFilter	Returns a Boolean value indicating whether the AutoFilter will be displayed.
	ShowTotals	Returns or sets a Boolean value to indicate whether the Total row is visible.
	SourceType	Returns one of the XlListObjectSourceType constants indicating the current source of the list.
	TotalsRowRange	Returns a Range object representing the Total row, if any, from a specified ListObject object.
	XmlMap	Returns an XmlMap object that represents the schema map used for the specified list.

Top

Public Methods

	Name	Description
	Delete	Deletes the ListObject object and clears the cell data from the worksheet.
	Publish	Publishes the ListObject object to a server that is running Microsoft Windows SharePoint Services.
	Refresh	Returns the current data and schema for the list from the server that is running Microsoft Windows SharePoint Services.
	Resize	The Resize method allows a ListObject object to be resized over a new range.
	Unlink	Removes the link to a Microsoft Windows SharePoint Services site from a list.
	Unlist	Removes the list functionality from a ListObject object.
	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