ADO.NET Provider for Excel

Build 20.0.7655

Null Value Mode

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

Data Type

string

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655