CData ADO.NET Provider for Excel Online 2019J - Online Help

Allow Formula

CData 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.

データ型

bool

デフォルト値

true

解説

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

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0