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