Getting StartedCData FireDAC Components for Google Sheets 2019 - Build 19.0.7354
Connecting from RAD Studio
The CData FireDAC Components for Google Sheets 2019 implement the standard FireDAC classes and integrate Google Spreadsheets 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 Google Spreadsheets
See Establishing a Connection to connect with the Data Explorer and FireDAC Connection Editor wizards.
Google Spreadsheets Version SupportThe component leverages the Google Drive API to enable bidirectional access to Google Sheets.
- See Creating VCL Applications to use the Form Designer to create a simple VCL application that queries Google Spreadsheets.
- 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 Google Spreadsheets-specific examples of executing prepared statements, discovering schemas, and writing other data access code.