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


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

When you connect, the 本製品 discovers the available columns and reflects both changes in Excel Online and configuration changes you make with the following connection properties. See the following sections to configure aspects of column discovery specific to Excel Online.

Configuring Column Name Detection

You can set Header to detect column names in a header row or you can reference columns alphabetically.

Header=True (Default)

Below are more specifics on how the 本製品 detects column names from a header row when Header is set to true.

  • The 本製品 determines columns from the first row of the worksheet. If no values are provided for the first row of the worksheet, the 本製品 creates unique, alphabetized column names that are available only within the scope of that request.
  • Headers should not contain special characters.
  • Due to a limitation of the Excel Online API, all column headers must be nonempty.


When Header is set to false, alphabetical column names will be dynamically assigned.

Primary Key

The 本製品 reports the row number as the primary key. The Id column for each row represents the row number from the top of the sheet.

For example, if you specify a range A3:E6, rows 3, 4, 5, and 6 will be returned.

Configuring Data Type Detection

Set TypeDetectionScheme to configure data type detection. By default, the 本製品 detects data types based on the cell format. However, you can also detect data types heuristically by scanning rows: set TypeDetectionScheme to "RowScan" and set RowScanDepth tothe number of rows to scan.

Configuring Column Value Parsing

Set the following properties to configure how Excel Online cell formats are parsed in select, insert, and update operations:

  • ValueRenderOption: Set this to configure how the 本製品 renders values in the output.
  • ValueInputOption: Set this to configure how the 本製品 parses values the user submits to Excel Online.

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