public IActionResult UpdateRange(AppendRangeDto range)
{
return(CheckSheetExist(range.Sheetname, () =>
{
var result = SheetsService.UpdateRange(
GoogleSheetsApi.SpreadSheetId,
new SheetRange(range.Sheetname, range.Range).ToRange(),
request => { },
range.Values);
return Ok(result);
}));
}
public IActionResult AppendRange(AppendRangeDto range)
{
return(CheckSheetExist(range.Sheetname, () =>
{
var result = SheetsService.AppendRange(
GoogleSheetsApi.SpreadSheetId,
SheetRange.ToRange(range.Sheetname, range.Range),
request =>
{
request.InsertDataOption = Google.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.AppendRequest.InsertDataOptionEnum.INSERTROWS;
},
range.Values);
return Ok(result);
}));
}
