Specifies whether the first row of the sheet contains column names when using the REST API.

Syntax

Connect-ExcelServices -Header bool

Data Type

bool

Default Value

true

Remarks

This property determines how the 本製品 names columns when reading data using the REST API and only applies when UseRESTAPI is set to true.

If this property is set to true, the 本製品 uses the values in the first row as column names.

If this property is set to false, the 本製品 assigns pseudo-column names such as A, B, C, and so on.

Use this property when your data includes column headers in the first row and you want the query results to reflect those names.