Indicates whether the data in Excel is laid out horizontally or vertically.

Possible Values

Data Type

string

Default Value

"Vertical"

Remarks

By default, this connection property is set to Vertical, meaning the server models vertically oriented spreadsheet data -- the server regards the rows in the spreadsheet, arranged below a header row, as rows.

If this connection property is set to Horizontal, the server regards the columns in the spreadsheet, arranged to the right of a header column, as rows.

A value of "Vertical" or "Horizontal" triggers the corresponding behavior for all sheets in selected workbooks, but you can override the set 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 "Horizontal" or "Vertical" as well).

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

For example, a value of Orientation=Horizontal, Sheet1=Vertical means that the orientation is set to horizontal for all sheets except Sheet1, which is 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.

When this connection property is set to Horizontal, the Header connection property uses the rows in the first column, rather than the columns in the first row, as the source of column names for the sheet tables in the server.