Connecting from RAD Studio
The CData FireDAC Components for Excel Online implement the standard FireDAC classes and integrate Excel Online into RAD Studio wizards. You can access the components from the RAD Studio Tool Palette and use the components alongside standard FireDAC classes like TFDQuery, TFDManager, and TFDConnection.
Connecting from Excel Online
See Establishing a Connection to connect with the Data Explorer and FireDAC Connection Editor wizards.
RAD Studio Version Support
RAD Studio 10.1 (Berlin) and above are supported.
Excel Online Version SupportThe component models spreadsheets and ranges as bidirectional tables that can be queried with SQL.
- See Creating VCL Applications to use the Form Designer to create a simple VCL application that queries Excel Online.
- See Writing Data Access Code to create TFDConnection objects. See Connection Definitions for other ways to create connections, with TFDManager for example.
- See Using the FireDAC Components for Excel Online-specific examples of executing prepared statements, discovering schemas, and writing other data access code.