在c#中使用googlesheets api v4获取命名范围列表

using Google.Apis.Auth.OAuth2;
using Google.Apis.Services;
using Google.Apis.Sheets.v4;
using Google.Apis.Sheets.v4.Data;
using System;
using System.Collections.Generic;
using System.IO;
using System.Threading;

public class SheetsApiExample
{
    static string[] Scopes = { SheetsService.Scope.SpreadsheetsReadonly };
    static string ApplicationName = "YourApplicationName";

    public static void Main(string[] args)
    {
        UserCredential credential;

        using (var stream =
            new FileStream("credentials.json", FileMode.Open, FileAccess.Read))
        {
            string credPath = "token.json";
            credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
                GoogleClientSecrets.Load(stream).Secrets,
                Scopes,
                "user",
                CancellationToken.None,
                new FileDataStore(credPath, true)).Result;
            Console.WriteLine("Credential file saved to: " + credPath);
        }

        var service = new SheetsService(new BaseClientService.Initializer()
        {
            HttpClientInitializer = credential,
            ApplicationName = ApplicationName,
        });

        string spreadsheetId = "YourSpreadsheetId";
        SpreadsheetsResource.GetRequest request =
                service.Spreadsheets.Get(spreadsheetId);

        request.Fields = "namedRanges"; // 只请求命名范围字段
        Spreadsheet response = request.Execute();
        IList<NamedRange> namedRanges = response.NamedRanges;

        foreach (var namedRange in namedRanges)
        {
            Console.WriteLine($"Named Range Name: {namedRange.Name}");
            Console.WriteLine($"Named Range Range: {namedRange.Range}");
        }
    }
}