Specifies the number of rows (or columns, when Orientation=Horizontal) immediately after the header to omit from query results.

Syntax

Connect-Excel -SkipTop int

Data Type

int

Default Value

0

Remarks

This connection property omits the specified the number of rows, among the rows immediately following the header row, to omit query results.

If the Orientation connection property is set to Horizontal, this applies to columns immediately following the header column.