ADO.NET Provider for Excel

Build 20.0.7655

Header

Indicates whether the first row should be used as a column header.

Data Type

string

Default Value

"true"

Remarks

If true, the first row will be used as a column header. Otherwise, the pseudo column names A, B, C, etc. will be used.

If you want to exclude any sheets from this rule you can set: Header=True, Sheet1= False (means headers are true for all sheets except Sheet1)

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655