ListColumn Interface

Definition

Represents a column in a list. The ListColumn object is a member of the ListColumns collection. The ListColumns collection contains all the columns in a list (ListObject object).

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

Remarks

Use the ListColumns property of the ListObject object to return a ListColumns collection.

Properties

_Default

Reserved for internal use.

Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.

DataBodyRange

Returns a Range object that is the size of the data portion of a column. Read-only.

Index

Returns the index number of the ListColumn object within the ListColumns collection. Read-only Integer.

ListDataFormat

Returns a ListDataFormat object for the ListColumn object. Read-only.

Name

Returns or sets the name of the list column. This is also used as the display name of the list column. This name must be unique within the list. Read/write String.

Parent

Returns the parent object for the specified object. Read-only.

Range

Returns a Range object that represents the range to which the specified list object in the above list applies. Read-Only.

SharePointFormula

Returns a String representing the formula in a calculated column. The formula is expressed in Excel syntax (US English locale, A1 notation). Read-only String.

Total

Returns the Total row for a ListColumn object. Read-only.

TotalsCalculation

Determines the type of calculation in the Totals row of the list column based on the value of the XlTotalsCalculation enumeration. Read/write.

XPath

Returns an XPath object that represents the Xpath of the element mapped to the specified Range object. Read-only.

Methods

Delete()

Deletes the column of data in the list. Does not remove the column from the sheet. If the list is linked to a Microsoft Windows SharePoint Services site, the column cannot be removed from the server and an error is generated.

Applies to