Specifies whether the first row (or column, when Orientation=Horizontal) is used as a source of column names.

Data Type

string

Default Value

"true"

Remarks

This connection property determines whether, among the sheets in the selected workbooks, the first row (or, if the Orientation connection property is set to Horizontal, the first column) is used as the source of column names for sheet table(s) in the server.

When this connection property is set to True, all sheets in selected workbooks source column names from the first row, or, if the Orientation connection property is set to Horizontal, the first column, of the sheet. When set to False, the server, by default, uses generic column names, such as A, B, C, or, if the Orientation connection property is set to Horizontal, R1, R2, R3, etc., in the resulting sheet tables exposed by the server.

A value of True or False triggers the corresponding behavior for all sheets in selected workbooks, but you can override the specified behavior on a sheet-by-sheet basis by appending a comma-separated list of rules to this connection property's value (you must add a comma after the initial "True" or "False" as well).

The syntax for these additional rules is <Sheet Name>=<"True" or "False">, where "Sheet Name" is the name of a sheet in one of the selected workbooks.

For example, the value True,Sheet1=False means all sheets named "Sheet1" (among sheets in the selected workbooks) use generic column names, and all other sheets in the selected workbooks get their column names from the first row of the sheet (assuming the Orientation connection property is set to Vertical). If there are multiple sheets across the selected workbooks that share the name "Sheet1", the same rule applies to all sheets by that name.