SSIS Components for Microsoft Excel

Build 24.0.8963

NullValueMode

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

Possible Values

ReadAsNull, ReadAsEmpty

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963