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

Syntax

Connect-Excel -NullValueMode string

Possible Values

Data Type

cstr

Default Value

"ReadAsNull"

Remarks

NullValueMode controls how empty Excel cells are modelled. An empty cell is a cell that has not been set and thus contains a null string. If NullValueMode is set to ReadAsNull, NULL is reported for an empty cell; if NullValueMode is set to ReadAsEmpty, an empty string is reported for an empty cell.