JDBC Driver for Microsoft Excel

Build 25.0.9434

NullValueMode

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

Possible Values

ReadAsNull, ReadAsEmpty

Data Type

string

Default Value

"ReadAsNull"

Remarks

An empty cell is a cell that has not been set and thus contains a null string.

Set this connection property to ReadAsEmpty to treat empty cells as empty strings.

Set this connection property to ReadAsNull to treat empty cells as NULL.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434