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.
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;
System.Object
combit.Reporting.DataProviders.GoogleSpreadsheetsDataProvider
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