Allow FormulaCData ADO.NET Provider for Excel Online 2019J - Build 19.0.7354
Whether or not to treat values starting with an equals (=) sign as formulas during inserts and updates.
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.
For example, with AllowFormula set to true, the following will insert a formula into the B column that will sum cells B1:B5:
INSERT INTO Excel_Sheet (A, B) VALUES ('Bill', '=SUM(B1:B5)')