FireDAC Components for Excel Online

Build 21.0.7930

Inserting ExcelOnline Data

You can execute INSERT statements when working with worksheets as tables. 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. Set ValueInputOption to configure input parsing.

Note that inserting to ranges is not supported.

Inserting with Headers

When the Header property is set to true, you can specify cells in a header row as the column names.

INSERT INTO Test_xlsx_Sheet1(Name, Amount) VALUES ('Test', 10)

Inserting without Headers

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

INSERT INTO Test_xlsx_Sheet1(A, B) VALUES ('Test', 10)

Inserting to a Range

Inserting to a range is not supported.

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