Cmdlets for Google Sheets

Build 24.0.9060

NullValueMode Parameter (Connect-GoogleSheets Cmdlet)

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

Syntax

Connect-GoogleSheets -NullValueMode string

Possible Values

ReadAsNull, ReadAsEmpty

Data 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060