共用方式為


XlColumnDataType Enumeration

Specifies how a column is to be parsed.

Version Information

Version Added: Excel 2007

Name

Value

Description

xlDMYFormat

4

DMY date format.

xlDYMFormat

7

DYM date format.

xlEMDFormat

10

EMD date format.

xlGeneralFormat

1

General.

xlMDYFormat

3

MDY date format.

xlMYDFormat

6

MYD date format.

xlSkipColumn

9

Column is not parsed.

xlTextFormat

2

Text.

xlYDMFormat

8

YDM date format.

xlYMDFormat

5

YMD date format.