Excel FireDAC Components

Easily connect Delphi & C++Builder Apps with real-time data from Excel spreadsheets. Use Excel to manage the data that powers your applications.

  • Connect to Excel Spreadsheets from Rad Studio Data Explorer.
  • Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
  • Use Excel Spreadsheets as simple real-time database to power Delphi & C++Builder Apps.

  download   buy now

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

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

Excel FireDAC Components Included in Enterprise & Enterprise PLUS Subscriptions


Get the Excel 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 := 'ExcelConnection';
FDConnection1.DriverName := 'CData.Fire.Excel';
with FDConnection1.Params as     
    TFDPhysCDataExcelConnectionDefParams do begin

    ...
end;


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

...

Type SQL, Get Excel


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

SELECT WITH INNER JOIN

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

AGGREGATE FUNCTIONS

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

CRUD OPERATIONS

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



Powerful Enterprise features