This documentation is archived and is not being maintained.

XlColumnDataType Enumeration

Office 2007
Specifies how a column is to be parsed.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlDMYFormat4DMY date format.
xlDYMFormat7DYM date format.
xlEMDFormat10EMD date format.
xlGeneralFormat1General.
xlMDYFormat3MDY date format.
xlMYDFormat6MYD date format.
xlSkipColumn9Column is not parsed.
xlTextFormat2Text.
xlYDMFormat8YDM date format.
xlYMDFormat5YMD date format.


Show: