A comma-separated list of cell values that the provider treats as null.

Data Type

string

Default Value

""

Remarks

Set this property to a comma-separated list of values that you want the provider to treat as null in query results. Matching is case-insensitive.

For example, setting this property to NaN,\N,N/A causes any cell containing "NaN", "\N", or "N/A" to return null instead of the literal text.

When a cell value matches an entry in this list, the provider applies the NullValueMode property to determine the returned value. The default behavior returns null for all column types. Set NullValueMode to ReadAsEmpty or ReadAsEmptyOrNull to return empty strings instead for matching cells.