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

Syntax

Connect-Excel -Header string

Data Type

cstr

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)