Connecting from RAD Studio
The CData FireDAC Components for Excel Services implement the standard FireDAC classes and integrate Excel Services 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 Services
See Establishing a Connection to connect with the Data Explorer and FireDAC Connection Editor wizards.
Excel Services Version SupportThe component supports retrieving Excel data from SharePoint On-Premises and SharePoint Online, through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.
- See Creating VCL Applications to use the Form Designer to create a simple VCL application that queries Excel Services.
- 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 Services-specific examples of executing prepared statements, discovering schemas, and writing other data access code.