Identifies a comma-separated list of values to read as null.

Syntax

Connect-Excel -NullValues string

Data Type

cstr

Default Value

""

Remarks

Set this connection property to a comma-separated list of values that you want the cmdlet to regard as null in query results.

For example: if you set this connection property to NaN,\N,N/A, then any cell containing "NaN", "\N", or "N/A" returns a null value.