Excel Online FireDAC Components

Rapidly create and deploy powerful Delphi & C++Builder Apps that integrate with live Excel Online Spreadsheet data!

  • Connect to Excel Online from Rad Studio Data Explorer.
  • Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
  • Integrate Delphi & C++Builder Apps with live Excel Online Spreadsheet data!

  download   buy now

CData FireDAC Components for Excel Online
 Included in FireDAC Subscriptions: 125+ Components for real-time data access.

Extend Delphi & C++Builder Apps with unrivaled data connectivity!

Excel Online FireDAC Components Included in Enterprise & Enterprise PLUS Subscriptions

Get the Excel Online FireDAC Components together with 125+ additional components for SaaS, NoSQL, and Big Data integration! Our components offer the fastest & easiest way to build data driven Apps.

Learn More  

FireDAC Components in Action

Connecting to Any Data Source is as Easy as Connecting to a Database

Standard FireDAC Components

Just like connecting with a typical RDBMS like MySQL. or SQL Server. Use standard FireDAC components like TDFManager, TDFConnection, TDFQuery, etc.

FDConnection1.Name := 'ExcelOnlineConnection';
FDConnection1.DriverName := 'CData.Fire.ExcelOnline';
with FDConnection1.Params as     
    TFDPhysCDataExcelOnlineConnectionDefParams do begin


FDConnection1.Connected := true;
FDQuery1.Active := true;
FDQuery1.Open('select * from Workbooks');


Type SQL, Get Excel Online

The easiest way to build data-centric applications. Write standard SQL queries to interact with Excel Online, just like working with any RDBMS. Supports joins, updates, aggregation, and more.


SELECT Workbooks.Id, Workbooks.Name, Workbooks.Fax,     
  Opportunity.AccountId, Opportunity.CloseDate
FROM Workbooks
INNER JOIN Opportunity
  ON Workbooks.Id = Opportunity.AccountId


SELECT Name, AVG(AnnualRevenue) FROM Workbooks GROUP BY Name


UPDATE Workbooks SET Name='John' WHERE Id = @myId

Powerful Enterprise features