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

ExcelOnline データの挿入

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

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 本製品 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 本製品 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 数式の使用 to configure formula evaluation.

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