A comma separated list which will be replaced with nulls if there are found in the CSV file.

Syntax

Connect-Excel -NullValues string

Data Type

cstr

Default Value

""

Remarks

A comma separated list which will be replaced with nulls if there are found in the CSV file. Example: "NaN,\N,N/A". If any of the specified values is found in a CSV row, it will be pushed as null.