ADO.NET Provider for Microsoft Excel

Build 23.0.8839

Orientation

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

Possible Values

Horizontal, Vertical

Data Type

string

Default Value

"Vertical"

Remarks

By default, the provider models vertically oriented spreadsheet data -- rows arranged vertically below a header row.

Set this to "Horizontal" if the rows are arranged left to right. The first column contains the column names and subsequent columns become rows.

The Header property is used in conjunction with the Orientation property. When Header is set to false and Orientation is set to Columns, column names are reported as R1, R2, R3, etc.

If you want to exclude any sheets from this rule you can set: Orientation=Horizontal, Sheet1=vertical (means orientation is set to horizontal for all sheets except Sheet1)

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839