NullValueMode Parameter (Connect-Excel Cmdlet)
Indicates whether empty cells are read as null or as empty.
Syntax
Connect-Excel -NullValueMode string
Possible Values
ReadAsNull, ReadAsEmpty, ReadAsEmptyOrNullData 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.
Set this connection property to ReadAsEmptyOrNull to return String values as empty strings, while all other data types are returned as NULL.