FireDAC Components for Excel Online

Build 21.0.7930


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


property AllowFormula: Boolean;

Data Type


Default Value



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)')

Note: If True, every column containing a formula will be exposed as String type regardless of the set TypeDetectionScheme.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930