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 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 本製品 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.