NullValueMode Parameter (Connect-GoogleSheets Cmdlet)
Indicates whether to read empty cells as null or as empty.
Syntax
Connect-GoogleSheets -NullValueMode string
Possible Values
ReadAsNull, ReadAsEmptyData Type
cstr
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.