ListDataFormat Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

The ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only.

public interface class ListDataFormat

[System.Runtime.InteropServices.Guid("0002447D-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ListDataFormat

Public Interface ListDataFormat

Attributes

GuidAttribute InterfaceTypeAttribute

Remarks

Use the ListDataFormat property of the ListColumn object to return a ListDataFormat object collection. The ListDataFormat object's Type property indicates the data type of the list column.

Properties

_Default	Reserved for internal use.
AllowFillIn	Returns a Boolean value indicating whether users can provide their own data for cells in a column (rather than being restricted to a list of values) for those columns that supply a list of values. Returns False for lists that are not linked to a SharePoint site. Also returns False if the column is not a specified as choice or multi-choice. Read-only Boolean.
Application	Returns an Application object that represents the Microsoft Excel application. Read-only.
Choices	Returns an Array of String values that contains the choices offered to the user by the ListLookUp, ChoiceMulti, and Choice data types of the DefaultValue property. Read-only Object.
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.
DecimalPlaces	Returns an Integer value that represents the number of decimal places to show for the numbers in the ListColumn object. Returns 0 if the Type property setting is not appropriate for decimal places. Returns xlAutomatic (-4105 decimal) if the Microsoft Windows SharePoint Services site is automatically determining the number of decimal places to show in the SharePoint list. Read-only Integer.
DefaultValue	Returns an Object representing the default data type value for a new row in a column. The Nothing object is returned when the schema does not specify a default value. Read-only Object.
IsPercent	Returns a Boolean value. Returns True only if the number data for the ListColumn object will be shown in percentage formatting. Read-only Boolean.
lcid	Returns an Integer value that represents the LCID for the ListColumn object that is specified in the schema definition. In Microsoft Excel, the LCID indicates the currency symbol to be used when this is an xlListDataTypeCurrency type. Returns 0 (which is the Language Neutral LCID) when no locale is set for the data type of the column. Read-only Integer.
MaxCharacters	Returns an Integer containing the maximum number of characters allowed in the ListColumn object if the Type property is set to xlListDataTypeText or xlListDataTypeMultiLineText. Returns -1 for columns whose Type property is set to a non-text value. Read-only Integer.
MaxNumber	Returns an Object containing the maximum value allowed in this field in the list column. The Nothing object is returned if a maximum value number has not been specified or if the Type property setting is such that a maximum value for the column is not applicable. Read-only Object.
MinNumber	Returns an Object containing the minimum value allowed in this field in the list column. This can be a negative floating point number. This property will return the Nothing object if no value has been specified for this field or if the setting of the Type property is such that a minimum value is not applicable to the column. Read-only Object.
Parent	Returns the parent object for the specified object. Read-only.
ReadOnly	Returns True if the object has been opened as read-only. Read-only Boolean.
Required	Returns a Boolean value indicating whether the schema definition of a column requires data before the row is committed. Read-only Boolean.
Type	Indicates the data type of the list column. Read-only XlListDataType.