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