Parameter HDR value:
HDR = Yes, which indicates that the first line is the title and is not used as data. If HDR = No is used, it indicates that the first line is not the title and used as data. The default value is yes.
Parameter Excel 8.0
Excel 8.0 is used for Excel 97 and later versions.
IMEX (Import Export mode) settings
IMEX has three modes:
0 is export Mode
1 is import Mode
2 is linked mode (full update capabilities)
Here I particularly want to explain the IMEX parameter, because different modes represent different read/write behaviors:
When IMEX = 0, the "Export mode" is enabled. The Excel files enabled in this mode can only be used for "writing" purposes.
When IMEX = 1, it is set to "Import mode". The Excel files opened in this mode can only be used for "read" purposes.
When IMEX = 2, the connection mode is enabled. The Excel files enabled in this mode support both "read" and "write.
Meaning:
0 --- output mode;
1 --- input mode;
2 ---- connection mode (full update capability)
From: http://www.cnblogs.com/goto/archive/2012/04/12/2443670.html
Personal Learning favorites