public ApiResponse CreateSpreadSheet(string name) { ApiResponse res = new ApiResponse(); try { var r = this.Auth(); if (r.Code != System.Net.HttpStatusCode.OK) { return(r); } var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = "Punnel", }); Google.Apis.Sheets.v4.Data.Sheet default_sheet = new Google.Apis.Sheets.v4.Data.Sheet(); default_sheet.Properties = new Google.Apis.Sheets.v4.Data.SheetProperties() { Title = "Punnel" }; List <Google.Apis.Sheets.v4.Data.Sheet> sheets = new List <Google.Apis.Sheets.v4.Data.Sheet>(); sheets.Add(default_sheet); var result = service.Spreadsheets.Create(new Google.Apis.Sheets.v4.Data.Spreadsheet() { Properties = new Google.Apis.Sheets.v4.Data.SpreadsheetProperties() { Title = name }, Sheets = sheets }).Execute(); if (result != null) { var pnsheet = result.Sheets[0]; Core.Entities.Integration.GoogleSheet.SpreadPunnelSheetViewModel result_data = new Core.Entities.Integration.GoogleSheet.SpreadPunnelSheetViewModel() { Id = result.SpreadsheetId, SheetId = pnsheet.Properties.SheetId }; res.Data = result_data; res.Code = System.Net.HttpStatusCode.OK; } } catch (Exception ex) { _log.Error(ex); res.Message = ex.Message; } return(res); }
public Data(GSheet gsheet) { _grid = gsheet.Data.First(); }
public Page(GSheet gsheet) { _grid = gsheet.Data.First(); }