ADO.NET Provider for Excel

Build 20.0.7655

Data Model

The CData ADO.NET Provider for Excel models Excel workbooks as relational databases. Spreadsheets and ranges comprise the tables.

Executing SQL to Spreadsheets

Excel Operations shows various ways to work with spreadsheet data.

Advanced Data Modeling

You can fine-tune the data model to match your workbook's organization. The provider supports reading data that is oriented vertically or horizontally, as well as sparse spreadsheets organized in user-defined ranges and named ranges.

See Advanced Settings to configure the connection string to control the tables the provider discovers, return values, and other aspects of data access.

Stored Procedures

In addition to working with the data in the spreadsheet, you can use the available stored procedures to change the metadata of an Excel file.

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