static string[] LoadTimetableFromRemoteSheet(string sheetsID, string column)
{
column = column.ToUpper();
var service = RemoteSheets.Auth();
var result = RemoteSheets.Read(service, sheetsID, "Лист1", $"{column}:{column}");
return(result
.Select(v => v.Any() ? v[0].ToString() : "").ToArray());
}
static void Tests()
{
//var credential = Auth();
//var service = CreateCalendarService(credential);
//RequestSample(service);
//CreateSampleEvent(service);
//var calendar = CreateSampleCalendar(service, "Test");
// EventCSVFormat.CreateCSVFile("test_calendar", new List<Event>() { event_});
//SheetsManager.Foo();
//Console.WriteLine(new DateTime().ToString("t", new System.Globalization.CultureInfo("en-US")));
var service = RemoteSheets.Auth();
var table = RemoteSheets.Read(service, "1zcN4wBLvq_tnYrY7BfGjW2zBhcX_rET0DO6iBgEFZPw", "Лист2", "B2");
CSVFormat.WriteCSVTable("table.csv", table);
}
