Specifies whether unset cells are read as NULL or as empty strings.

Possible Values

Data Type

string

Default Value

"ReadAsNull"

Remarks

By default, unset cells appear as NULL in query results. This is different from cells that have been set to an empty value, or had their values removed. Use this property to control what the provider returns for unset Microsoft Excel Online cells.

Permitted values are:

• ReadAsNull: Unset cells are reported as NULL.
• ReadAsDefault: Unset cells are reported as empty strings.
• ReadAsEmpty (Deprecated): If this value is currently set, update it to ReadAsDefault for equivalent behavior.
• ReadAsEmptyOrNull: Unset cells in string columns are reported as empty strings, and unset cells in other columns are reported as NULL.