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

Possible Values

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.