Power BI Connector for Microsoft Excel Online

Build 23.0.8839


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

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

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