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

Data Type

bool

Default Value

true

Remarks

This property determines whether the server 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 server 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.