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


In This Topic
    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
    GoogleSpreadsheetsDataProvider Class
    Syntax
    '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 7, .NET 8

    See Also