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

Syntax

Connect-ExcelOnline -NullValueMode string

Possible Values

Data Type

cstr

Default Value

"ReadAsNull"

Remarks

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

• ReadAsNull: An empty cell is reported as NULL.
• ReadAsEmpty: An empty cell is reported as an empty string.
• ReadAsEmptyOrNull: An empty cell in a string column is reported as an empty string, and an empty cell in other columns is reported as NULL.