Learn more
 

CData Software - Knowledge Base

Recent Google Sheets ADO.NET Articles

DataBind Google Sheets to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Google Sheets with the DevExpress Windows Forms and Web controls to provide Google Sheets to a chart.

Export Data from SQL Server to Google Sheets through SSIS

Easily push SQL Server data to Google Sheets using the CData SSIS Tasks for Google Sheets.

LINQ to Google Sheets

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Google Sheets Data Provider.

How to Access Google Sheets Using Entity Framework

This article shows how to access Google Sheets using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Automate Google Sheets Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Google Sheets from PowerShell? This article demonstrates how to utilize the Google Sheets Cmdlets for tasks like connecting to Google Sheets, automating operations, downloading data, and more.

Provide OData Services of Google Sheets from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Google Sheets by developing a WCF Service Application.

Deploy the ADO.NET Provider for Google Sheets on an SSRS Report Server

Connect to Google Sheets from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid

Learn how you can connect Google Sheets to Infragistics XamDataGrid to build dynamic grids.

Build an OLAP Cube in SSAS from Google Sheets

Establish a connection to Google Sheets data from SQL Server Analysis Services, and use the Google Sheets Data Provider to build OLAP cubes for use in analytics and reporting.

How to Import Google Sheets into SQL Server using SSIS

Easily back up Google Sheets to SQL Server using the SSIS components for Google Sheets.