Specifies whether to read cells containing empty strings as empty or as null.

Syntax

Connect-Excel -EmptyValueMode string

Possible Values

Data Type

cstr

Default Value

"ReadAsEmpty"

Remarks

An empty value is a cell which contains an empty string (e.g., ""). Empty values are different from cells that have not been set, which contain null values.

To treat empty values as empty strings, set this connection property to ReadAsEmpty.

To treat empty values as NULL, set this connection property to ReadAsNull .