public bool ConnectToGoogleSheet(IWin32Window owner) { if (google == null) { var auth = GoogleOAuth.Authorize(); if (auth == null) { return(false); } google = new GSheetService(auth); } using (var ws = new WorksheetSelector(google)) { if (ws.ShowDialog() == DialogResult.OK) { settings.SpreadsheetName = ws.SelectedSpreadsheet.Title; settings.SpreadsheetURL = ws.SelectedSpreadsheet.Url; settings.WorksheetName = ws.SelectedWorksheet.Title; settings.WorksheetCellsFeedURI = ws.SelectedWorksheet.CellsFeedURI; settings.WorksheetListFeedURI = ws.SelectedWorksheet.ListFeedURI; LogInfo("Connected to Spreadsheet: " + settings.GetSheetDescription()); return(true); } } return(false); }
public WorksheetSelector(GSheetService google) { InitializeComponent(); this.google = google; }