public static AppendValuesResponse AppendRowLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.AppendRequest> onRequest, params object[] rowValues) { var values = new List <IList <object> > { rowValues.ToList() }; return(service.AppendRange(spreadsheetId, range, onRequest, values)); }
public static AppendValuesResponse AppendColumnLine(this SheetsService service, string spreadsheetId, string range, Action <SpreadsheetsResource.ValuesResource.AppendRequest> 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.AppendRange(spreadsheetId, range, onRequest, values)); }
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); })); }