JDBC Driver for Google Sheets

Build 24.0.9060

IgnoreErrorValues

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.

Data Type

bool

Default Value

true

Remarks

If this property is set to true, the driver returns fields containing value errors as NULL.

When this property is set to false, the driver throws an error if a value error is discovered.

The driver checks for the following error values:

  • #NULL!
  • #N/A
  • #DIV/0!
  • #VALUE!
  • #REF!
  • #NAME?
  • #NUM!
  • #ERROR!

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