CData FireDAC Components for Excel Online
The CData FireDAC Components for Excel Online allow you to use FireDAC classes to build applications with bidirectional access to Excel Online. 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.
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.