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

Syntax

Connect-ExcelOnline -NullValueMode string

Possible Values

Data Type

cstr

Default Value

"ReadAsNull"

Remarks

NullValueMode controls how empty cells are modeled. 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.