Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
XlColumnDataType Enumeration
Collapse the table of content
Expand the table of content

XlColumnDataType Enumeration 

Specifies how a column is to be parsed.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

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

Community Additions

© 2015 Microsoft