Determines whether empty rows are included in query results.

Syntax

Connect-Excel -ShowEmptyRows SwitchParameter

Data Type

bool

Default Value

false

Remarks

If this connection property is set to True, empty rows are included in query results.

If this connection property is set to False, empty rows are excluded from query results.