combit List & Label 30 - .NET Help
combit.Reporting.DataProviders Namespace / GoogleSpreadsheetsDataProvider Class
Members Example


GoogleSpreadsheetsDataProvider Class

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
GoogleSpreadsheetsDataProvider Class
Syntax
'Declaration
 
Public NotInheritable Class GoogleSpreadsheetsDataProvider 
   Implements 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

See Also