GoogleSpreadsheetsDataProvider Class

In This Topic

Use this data provider to access Google Spreadsheets data.

You need a valid Google account and must provide access to the data via Google Sheets or the Google Developers Console. Proceed as follows:

Table ID: For the table ID refer to the release link (see below).

Data source is published on the web: Publish a file in Google Sheets via "File > Publish to the web". The generated link contains the table ID, e.g. https://docs.google.com/spreadsheets/d/ {Table ID} /pubhtml.

If the data source is not published on the web, the data must be enabled to read via the Google Developers Console. Go to Google Developers Console and proceed as follows: "Projectname" > Permissions > Add Member. Now this account must be authenticated via OAuth 2.0. A so-called Access Token is required for the actual access, which can be generated from the Refresh Token that never expires.

Object Model

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public NotInheritable Class GoogleSpreadsheetsDataProvider 
   Implements IDataProvider

public sealed class GoogleSpreadsheetsDataProvider : IDataProvider

public ref class GoogleSpreadsheetsDataProvider sealed : public IDataProvider

Example

The table is published to the web

var provider = new GoogleSpreadsheetsDataProvider("<Table ID>", true);
LL.DataSource = provider;

The table is shared with specific users only

var provider = new GoogleSpreadsheetsDataProvider("<Table ID>", true, "refreshToken", "clientID", "clientSecret")
LL.DataSource = provider;

Inheritance Hierarchy

System.Object
combit.Reporting.DataProviders.GoogleSpreadsheetsDataProvider

Requirements

Platforms: Windows 10 (Version 21H2 - 23H2), Windows 11 (21H2 - 22H2), Windows Server 2016 - 2022
.NET: .NET Framework 4.8, .NET 6, .NET 8, .NET 9

Reference

GoogleSpreadsheetsDataProvider Members
combit.Reporting.DataProviders Namespace

Send Feedback