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