FireDAC Components for Excel Services

Build 20.0.7587

CData FireDAC Components for Excel Services

Overview

The CData FireDAC Components for Excel Services allow you to use FireDAC classes to build applications with bidirectional access to Excel Services. FireDAC provides a unified, high performance data access layer for working with enterprise databases in RAD Studio. The components abstract the underlying data source into tables, views, and stored procedures that can be used to both retrieve and update data.

Getting Started explains how to connect with the Data Explorer and create a simple VCL application with the Form Designer. Using the FireDAC Components describes how to use the components from code.

SQL Compliance the SQL syntax and examples.

An important feature of the components is the ability to easily cache data locally. This allows the components to be used in an offline mode when access to the data source is not possible. See Caching Data for more details on this feature.

Data Model lists the tables, views, and stored procedures available for the components.

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