FireDAC Components for Excel Online

Build 21.0.7930

Updating ExcelOnline Data

In UPDATE statements, you can specify the column names detected from a header row or specify the alphabetical column names in Excel Online. You can also configure how the component parses the input values into Excel Online cell formats.

Set the Header property to configure column names. The primary key is the row number; specify the primary key with the Id column. Set ValueInputOption to configure input parsing.

Updating with Headers

When the Header property is set to true, you update columns by specifying the detected column names.

UPDATE Customers SET Col1='value' WHERE Id=7

Updating without Headers

When the Header is set to false, provide the alphabetical column names:

UPDATE Customers SET H='value' WHERE Id=7

Updating Ranges

Set the columns corresponding to the range and specify the row number as the Id:

UPDATE [Customers#A15:C15] SET A='Ana Trujilo', B='Northwind, Inc.', C='100,000' WHERE Id='15'

Configuring Input Parsing

By default, the component parses all values you input in the SQL statement the same as if you entered the input in the Excel Online UI. For example, strings may be converted to numbers, dates, etc.

To disable the parsing of input values, set ValueInputOption. Additionally, see Using Formulas to configure formula evaluation.

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