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

Syntax

property NullValueMode: String;

Possible Values

Data Type

String

Default Value

"ReadAsNull"

Remarks

NullValueMode controls how empty Google Sheets 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.