ListColumn Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

GuidAttribute InterfaceTypeAttribute

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.