Indicates whether empty cells are read as null or as empty.

Syntax

Connect-Excel -NullValueMode string

Possible Values

Data Type

cstr

Default Value

"ReadAsNull"

Remarks

An empty cell is a cell that has not been set and thus contains a null string.

Set this connection property to ReadAsEmpty to treat empty cells as empty strings.

Set this connection property to ReadAsNull to treat empty cells as NULL.