ListColumn Members
Include Protected Members
Include Inherited Members
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).
The ListColumn type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
_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. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
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. |
Top