public static UpdateValuesResponse UpdateRowLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.UpdateRequest> onRequest, params object[] rowValues) { var values = new List <IList <object> > { rowValues.ToList() }; return(service.UpdateRange(spreadsheetId, range, onRequest, values)); }
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 static UpdateValuesResponse UpdateColumnLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.UpdateRequest> onRequest, params object[] columnValues) { // convert columnValues to columList var columList = columnValues.Select(v => new List <object> { v }); // Add columList to values and input to valueRange var values = new List <IList <object> >(); values.AddRange(columList.ToList()); return(service.UpdateRange(spreadsheetId, range, onRequest, values)); }