Specifies whether the provider includes empty rows when reading data from a worksheet.

Syntax

Connect-ExcelServices -ShowEmptyRows bool

Data Type

bool

Default Value

true

Remarks

This property determines whether the 本製品 includes completely empty rows in the output when reading data from a worksheet and only applies when UseRESTAPI is set to true.

If this property is set to true, the 本製品 includes empty rows in the result set.

If this property is set to false, it skips them.

Use this property when empty rows in your spreadsheet are meaningful and should be preserved in the output.