Specifies whether the provider should ignore formula calculation errors in Excel worksheets.

データ型

bool

デフォルト値

true

解説

This property controls how the connector handles formula calculation errors when reading Excel data.

If set to true, the connector ignores any errors that occur during formula evaluation. While this may result in unreliable values for calculated fields, other non-calculated data remains accurate.

If set to false, the connector stops processing if a calculation error occurs.

Use this property when you want to load available data despite potential issues in calculated cells.