This documentation is archived and is not being maintained.

XlColumnDataType Enumeration 

Specifies how a column is to be parsed.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlColumnDataType1 As XlColumnDataType = XlColumnDataType.xlDMYFormat

public enum XlColumnDataType
public enum XlColumnDataType
public enum XlColumnDataType

Member nameDescription
xlDMYFormatDMY date format.
xlDYMFormatDYM date format.
xlEMDFormatEMD date format.
xlMDYFormatMDY date format.
xlMYDFormatMYD date format.
xlSkipColumnColumn is not parsed.
xlYDMFormatYDM date format.
xlYMDFormatYMD date format.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms