c# - 如何使用 C# 动态创建谷歌表格并直接导出网格数据？

Question

我尝试了下面给出的用于创建电子表格的代码，但在这一行var file = request.Execute();出现错误 如何解决这个问题：

    public Google.Apis.Drive.v3.Data.File CreateSheet()
    {
        string[] scopes = new string[] { DriveService.Scope.Drive,DriveService.Scope.DriveFile,}; 
        var clientId = "666641765201-qbo62utelvp1lf7iu4um406fdp6d77md.apps.googleusercontent.com";
        var clientSecret = "0Ts_Vy0-ssBLBvSTlMeu8R66";
        var credential = GoogleWebAuthorizationBroker.AuthorizeAsync(new ClientSecrets
        {
            ClientId = clientId,
            ClientSecret = clientSecret
        }, scopes,
        Environment.UserName, CancellationToken.None, new FileDataStore("MyAppsToken")).Result;     
        DriveService _service = new DriveService(new BaseClientService.Initializer()
        {
            HttpClientInitializer = credential,
            ApplicationName = "MyAppName",
        });
        var _parent = "";
        var filename = "helloworld";
        var fileMetadata = new Google.Apis.Drive.v3.Data.File()
        {
            Name = filename,
            MimeType = "application/vnd.google-apps.spreadsheet",           
        };
        FilesResource.CreateRequest request = _service.Files.Create(fileMetadata);
        request.SupportsTeamDrives = true;
        fileMetadata.Parents = new List<string> { _parent };  
        request.Fields = "id";
        System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate (object sender, 
        X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return true; };
        var file = request.Execute();
        Console.WriteLine("File ID: " + file.Id);
        return file;
    }

标签： c#sqlasp.netgoogle-sheets-api