public GSRepository(string applicationName, string pathToCredentials, string tableURL)
{
Scopes = new string[] { SheetsService.Scope.Spreadsheets };
ApplicationName = applicationName;
SetUpCredential(pathToCredentials);
SetUpDefaultService();
CurrentSheetId = null;
CurrentSheetInfo = null;
ChangeTable(tableURL);
}
public void SetUpSheetInfo()
{
if (CurrentSheetId is null)
{
throw new Exception("CurrentSheetId should be specified first");
}
var metadata = Service.Spreadsheets
.Get(CurrentSheetId)
.Execute();
CurrentSheetInfo = new SheetInfo(metadata);
}