IgnoreErrorValues Parameter (Connect-GoogleSheets Cmdlet)
When enabled, fields where the provider detects error values will be returned as NULL. If disabled, the provider throws an error if an error value is detected in any field.
Syntax
Connect-GoogleSheets -IgnoreErrorValues bool
Data Type
bool
Default Value
true
Remarks
If this property is set to true, the cmdlet returns fields containing value errors as NULL.
When this property is set to false, the cmdlet throws an error if a value error is discovered.
The cmdlet checks for the following error values:
- #NULL!
- #N/A
- #DIV/0!
- #VALUE!
- #REF!
- #NAME?
- #NUM!
- #ERROR!
This is a required parameter.