Indicates whether to read the empty values as empty or as null.

Syntax

Connect-Excel -EmptyValueMode string

Possible Values

Data Type

cstr

Default Value

"ReadAsEmpty"

Remarks

Possible values are ReadAsEmpty and ReadAsNull. An empty value is a cell which contains an empty string (e.g., =""), which is different from a cell that has not been set and thus contains a null string.