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);
        }