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

Syntax

Connect-ExcelOnline -Header bool

Data Type

bool

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.

The cmdlet will follow the additional specifications below to detect column headers:

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