Whether or not to treat values starting with an equals (=) sign as formulas during INSERTs and updates.

Syntax

Connect-Excel -AllowFormula bool

Data Type

bool

Default Value

true

Remarks

Set this value to true to treat values beginning with an equals (=) sign as formulas on INSERTs and updates. Set the value to false to treat all values used in INSERTs and updates as strings.