ADO.NET Provider for Microsoft Excel

Build 23.0.8839

EmptyValueMode

Indicates whether to read the empty values as empty or as null.

Possible Values

ReadAsEmpty, ReadAsNull

Data Type

string

Default Value

"ReadAsEmpty"

Remarks

Possible values are ReadAsEmpty and ReadAsNull. An empty value is a cell which contains an empty string (e.g., =""), which is different from a cell that has not been set and thus contains a null string.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839