Google Sheets and .NET Core with C# Log

 

https://developers.google.com/sheets/api/quickstart/dotnet#prerequisites
https://developers.google.com/sheets/api/quickstart/dotnet

using GetGooglForm.Models;

using Google.Apis.Auth.OAuth2;

using Google.Apis.Services;

using Google.Apis.Sheets.v4;

using Google.Apis.Sheets.v4.Data;

using Google.Apis.Util.Store;

using Microsoft.AspNetCore.Mvc;

using Microsoft.Extensions.Logging;

using System;

using System.Collections.Generic;

using System.Diagnostics;

using System.IO;

using System.Linq;

using System.Threading;

using System.Threading.Tasks;

namespace GetGooglForm.Controllers

{

    public class HomeController : Controller

    {

        private readonly ILogger<HomeController> _logger;

        public HomeController(ILogger<HomeController> logger)

        {

            _logger = logger;

        }

        static string[] Scopes = { SheetsService.Scope.SpreadsheetsReadonly };

        static string ApplicationName = "Google Sheets API .NET Quickstart";

        public IActionResult Index()

        {

            UserCredential credential;

            using (var stream =

                new FileStream("credentials.json", FileMode.Open, FileAccess.Read))

            {

                // The file token.json stores the user's access and refresh tokens, and is created

                // automatically when the authorization flow completes for the first time.

                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 = "1Q5453yQJlW0LP7WvoZf6O_IsQNq7tESz2EARbfr1zuo";

            String range = "A2:E3";

            SpreadsheetsResource.ValuesResource.GetRequest request =

                    service.Spreadsheets.Values.Get(spreadsheetId, range);

            // Prints the names and majors of students in a sample spreadsheet:

            // https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit

            ValueRange response = request.Execute();

            IList<IList<Object>> values = response.Values;

            if (values != null && values.Count > 0)

            {

               // Console.WriteLine("Name, Major");

                foreach (var row in values)

                {

                    // Print columns A and E, which correspond to indices 0 and 4.

                    Console.WriteLine("{0}, {1}", row[0], row[4]);

                }

            }

            else

            {

                Console.WriteLine("No data found.");

            }

            //Console.Read();

            return View();

        }

        public IActionResult Privacy()

        {

            return View();

        }

        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]

        public IActionResult Error()

        {

            return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });

        }

    }

}