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


CData ADO.NET Provider for Excel Online 2019J - Build 19.0.7354

Set the following properties to configure formula evaluation when executing SELECT, INSERT, and UPDATE statements.

Selecting Formulas

The 本製品 can return either the result of the formula or the formula itself; configure this behavior with the ValueRenderOption connection property.

Inserting and Updating Formulas

Set AllowFormula to true to insert formulas (the default). Otherwise, all values used in inserts and updates are inserted as string literals.

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