Indicates whether or not the provider should detect column names from the first row.

Data Type

bool

Default Value

true

Remarks

If Header is set to True, the first row is used as a column header. If Header is set to False, the pseudo column names A, B, C, etc. are used.

The connector also follows these rules for detecting column headers:

• Headers should not contain special characters.
• Due to a limitation of the Excel Online API, all column headers must be nonempty.